I am looking for a function that would test a field value for numeric or text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 26 May 2006 14:39 GMT

Is there a function that would test a value to see if it is numeric or text?

These values are in a text field.

Examples:

123456 = Numeric

DMSmith = Text

or somehing like this

Thanks

dave

Reply to this Message

John Spencer - 26 May 2006 16:36 GMT

IsNumeric([SomeField]) will return True if the entire contents of the field
can be treated as a number.

There is a little bit of a glitch in this. If the entry could be treated as
a scientific notation number then that will recieve True.

IsNumeric should return true for
Strings with only numbers
Strings with a plus or a minus sign at the beginning or end of a string of
numbers
Strings with one "e" or one "d" inside a string of numbers (scientific
notation)
All the above with leading or trailing spaces
Also any number of spaces between the plus or minus sign and a string of
numbers

> Is there a function that would test a value to see if it is numeric or
> text?
[quoted text clipped - 12 lines]
>
> dave

Reply to this Message

Dave - 26 May 2006 18:38 GMT

Thanks it gives me a place to start

Dave

> IsNumeric([SomeField]) will return True if the entire contents of the
> field can be treated as a number.
[quoted text clipped - 28 lines]
>>
>> dave

Reply to this Message