Help in Validation

[sharonbl]

I have a problem in some validation, that is I need to validate a string of 3 characters with no numeric values and I actually used the IsNumeric Function, however, it is true only when I enter only numbers and if I enter "12f", it returns false. How can I make it return True?
any other function to use other then IsNumeric Function?
Thanks

 

[Former]

Are you just trying to make sure that there are only three characters in the string ?

 

[chrismcbride]

Sharon
If you want to test if any one character in your string is a number, use Len to get the length of the string. Then loop through each character using Mid and test the return with IsNumeric. Help file has good stuff on Mid and Len
Good Luck
Chris

 

[sharonbl]

Thanks guys...
It works...