validation rule for exactly 5 digits, including leading zeros

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

Top