Validation Rule

Chipcom

Registered User.
Local time
Today, 20:41
Joined
Apr 13, 2006
Messages
63
Hi

I need to know how to set a rule to a password field that the user
only be able to type english letters and numbers .


Any idea how?


Thanks
 
Try the following validation rule

Not Is Null And NOT LIKE "*[!0-9A-Z]*"

For a field in a table, and just in case you'll be updating through for instance ADO, you might want to deal with ADO wildcards too.

Not Is Null And NOT LIKE "%[!0-9A-Z]%" And NOT LIKE "*[!0-9A-Z]*"
 
Thanks

It's works fine
 

Users who are viewing this thread

Back
Top Bottom