Valdation Rule

  • Thread starter Thread starter Jason Frazer
  • Start date Start date
J

Jason Frazer

How can i set up a valadation rule that will make the user
input 5 characters or digits, and only 5. This will be a
constant.

Thanks

Jason Frazer
 
The rule would require the user to input 5 characters. The
user can not enter 4 or 6 values... they have to enter 5
or leave as a Null value.

Example: 00473 or 4R34R

Thanks for any help
 
The rule would require the user to input 5 characters. The
user can not enter 4 or 6 values... they have to enter 5
or leave as a Null value.

Example: 00473 or 4R34R

Thanks for any help
Click to expand...

I'm not sure you understood the response. What Frank proposed:

Like "?????"

is a validation rule that will do what you want, though you may need

Like "?????" Or Is Null
 
Back
Top