Prohibiting entry of special characters in a field

E

Evan M

Hello,

I need to restrict the values entered into a text box to only A-Z and 0-9.
Basically, I don't want the user to enter any special characters as they
tend to confuse the other users. If anyone has any advice, it would be
greatly appreciated!

Thanks,
Evan M.
evan AT radiologyonesource DOT com
 
J

John Vinson

Hello,

I need to restrict the values entered into a text box to only A-Z and 0-9.
Basically, I don't want the user to enter any special characters as they
tend to confuse the other users. If anyone has any advice, it would be
greatly appreciated!

Thanks,
Evan M.
evan AT radiologyonesource DOT com
Click to expand...

Use a validation rule of

NOT LIKE [!0-9!A-Z]

John W. Vinson[MVP]
 
M

Marshall Barton

Evan said:
I need to restrict the values entered into a text box to only A-Z and 0-9.
Basically, I don't want the user to enter any special characters as they
tend to confuse the other users. If anyone has any advice, it would be
greatly appreciated!
Click to expand...


Set the text box's Validation Rule property to:

Not Like "*[!A-Z0-9]*"
 
Top