Function to check value is character

[Longia]

Can any body help me with this? I need a function that checks for character value in field.

 

[TomKane]

You could use the asc function - that works one one character at a time.

 

[zemp]

Do you mean that you want to check if the field value is a string data type as opposed to a number data type?

If so you could use the IsNumeric function and if it returns false then your field data is a string. Thanks and Good Luck!

zemp

 

[Longia]

To be very precise I need a funtion that tells me that all the characters in the field (like "TOMKANE&quot are actually character not numeric.

 

[zemp]

Use the IsNumeric function logic on each character individually. Or use and asc function to return your individual character code and then you can add logic to compare the returned character code with the Ascii character set to determine if it is a string. Thanks and Good Luck!

zemp

 

[Longia]

Thanks a lot for help zemp and Tomkane