Test for Alphanumeric

  • Thread starter Thread starter JimS
  • Start date Start date
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.
 
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
 
Back
Top