validation rule for exactly 5 digits, including leading zeros

J

jlo1524

Joined
Apr 16, 2011
Messages
1
Reaction score
0
I need help with creating a validation rule in a table for a number that is exactly 5 digits, and i need it to include the leading zeros.

all i found was:
=len(trim(a1))=6 (works in excel, not access)
&
Is Null Or Between 10000 And 99999 (which doesn't appear to include the leading zeros)

Please HELP!!! :D
 

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

Similar Threads

Exporting Leading Zeroes to .txt file 2
Leading Zeros 7
Trim leading zeros 3
Droping Leading Zeros In Table 4
Need 7 digit number with differnt number of leading zeros 10
Adding in leading zeros and a space to a text field in a table 4
Validation rules - digits & letters only 1
how to update a field to include leading zeros? 1

Back
Top