testing for numeric or alpha

[Michelle W.]

How do I test a text field for numeric data? How do I test a text field for
alpha data?

 

[vanderghast]

? IsNumeric("33.6"), IsNumeric("44A"), val("44a")
True False 44


So, IsNumeric can do, if the whole field has to be numerical, else, val( )
can extract the first number seen.


Not IsNumeric is an "alpha" field, or you mean "alpha' is only a text that
will NOT contain any digit? if so, the NOT LIKE "*[0-9]*" could do.



Vanderghast, Access MVP

 

[Marshall Barton]

How do I test a text field for numeric data? How do I test a text field for
alpha data?

Numeric is kind of vague. If you mean all decimal digits.
you can use this kind of comparison:

Not ([text field] Like "*[!0-9]*")

similarly for all alphabetic characters:

Not ([text field] Like "*[!a-z]*")