Validation rule- Can't begin with 5

jamphan

Registered User.
Local time
Today, 10:14
Joined
Dec 28, 2004
Messages
143
I need to have a validation rule on a form that will not allow users to input any number that begins with a 5. The field is a text field because it requires 16 digits for each number. Is there a way I can stop the user from entering any number that starts with 5? Thanks for the help.
 
Insert a validation rule for that field in your table as follows:

Left([Field],1)<>5

:cool:
 

Users who are viewing this thread

Back
Top Bottom