What I need is a test that what is entered only contains the digits 0123456789.
Anybody have a nice quick way to test for a valid whole number between 1 and 99999? Testing for values < 1 and > 99999 are immaterial to this question and are already tested. I thought DATATYPE(number,"W") would do it but 100E2 and 100.0 are valid. DATATYPE HEX and ALPHANUMERIC allow for 100E2