Access VBA Function - is number? required

mudster01

Registered User.
Local time
Today, 20:57
Joined
Aug 27, 2006
Messages
10
Hi All
Can anyone help me with code to find out whether a field consists of numbers or not i.e. similar to the excel function IsNumber.
Your help is much appreciated.
I assume i need to pass the field as a parameter to the function & loop through each char, but stuck on how to check each = 0 to 9.
Thanks,
M
 
ah, someone has kindly pointed out the function "isnumeric".
 

Users who are viewing this thread

Back
Top Bottom