Test for Alphanumeric

[JimS]

I can't remember the simple test for alphanumeric in a field. I've seen it a
hundred times, but can't find it. I have a text field (it's the 'sheet name'
from an Excel spreadsheet...) that I need to verify contains only
alphanumeric characters. Quick method? (A2003)

Thanks in advance.

 

[Marshall Barton]

I can't remember the simple test for alphanumeric in a field. I've seen it a
hundred times, but can't find it. I have a text field (it's the 'sheet name'
from an Excel spreadsheet...) that I need to verify contains only
alphanumeric characters. Quick method? (A2003)

If Me.textfield Like "*[!a-z0-9]*" Then
' there is a funky character
Else
' it is all alphanumerics
End If