Valdation Rule

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
 
G

Guest

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
 
D

Dirk Goldgar

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

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
 

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