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

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!


Set the text box's Validation Rule property to:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top