determining if an entry is a number

Hi guys

I am creating an exchange program with quickbooks and tables it imports are text fields, even ones that represent numbers.

so, I must create a validation rule that ensures only numbers are entered in those fields. There is a function in Javascript - NaN that can tell validate if user entered text and not a number. Does anybody have function like this?

Thanks,
David

VBA has a function called IsNumeric, which will return True or False
depending upon whether the argument given to it is numeric or not.

?IsNumeric("1234.56")
True

?IsNumeric("ABS123")
False


--

Ken Snell
MS ACCESS MVP

"dp" wrote in message
...
Hi guys

I am creating an exchange program with quickbooks and tables it imports
are text fields, even ones that represent numbers.

so, I must create a validation rule that ensures only numbers are entered
in those fields. There is a function in Javascript - NaN that can tell
validate if user entered text and not a number. Does anybody have function
like this?

Thanks,
David

But be aware that D and E are treated as numbers if they're in the midst of
the digits:

?IsNumeric("12E34")
True
?IsNumeric("12D34")
True


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Ken Snell" wrote in message
...
VBA has a function called IsNumeric, which will return True or False
depending upon whether the argument given to it is numeric or not.

?IsNumeric("1234.56")
True

?IsNumeric("ABS123")
False


--

Ken Snell
MS ACCESS MVP

"dp" wrote in message
...
Hi guys

I am creating an exchange program with quickbooks and tables it imports
are text fields, even ones that represent numbers.

so, I must create a validation rule that ensures only numbers are
entered
in those fields. There is a function in Javascript - NaN that can tell
validate if user entered text and not a number. Does anybody have
function
like this?

Thanks,
David

Excellent point.

The alternative if such things are not to be allowed, dp, would be to write
a function that literally looks at each character and determines if that
character is a number or not.

--

Ken Snell
MS ACCESS MVP

"Douglas J. Steele" wrote in message
...
But be aware that D and E are treated as numbers if they're in the midst
of
the digits:

?IsNumeric("12E34")
True
?IsNumeric("12D34")
True


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Ken Snell" wrote in message
...
VBA has a function called IsNumeric, which will return True or False
depending upon whether the argument given to it is numeric or not.

?IsNumeric("1234.56")
True

?IsNumeric("ABS123")
False


--

Ken Snell
MS ACCESS MVP

"dp" wrote in message
...
Hi guys

I am creating an exchange program with quickbooks and tables it
imports
are text fields, even ones that represent numbers.

so, I must create a validation rule that ensures only numbers are
entered
in those fields. There is a function in Javascript - NaN that can tell
validate if user entered text and not a number. Does anybody have
function
like this?

Thanks,
David