Test for Alphanumeric

J

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.
 
M

Marshall Barton

JimS said:
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)
Click to expand...


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