Validation Rule: 8 Numbers Only 1

[Quintios]

I have a field where someone has to enter a number. The number will always be comprised of 8 digits. How do I set the validation rule to force the person to enter 8 digits exactly?

Thanks in advance! Onwards,

Q-

 

[psemianonymous]

Maybe store the field as a Text field (assuming you will have leading zeroes--which you will) and have the Validation Rule as "########". --
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

 

[Quintios]

Thanks!

I imagine that if you sort on those numbers, even though they are stored as text, they'll sort the same as if I had stored them as numbers, right?

Onwards,

Q-

 

[psemianonymous]

Yes. Numbers 0-9 are stored in proper order. You only get into trouble when doing a "binary compare" on lowercase-and-uppercase letters (i.e. 'a' > 'A'; 'a' > 'Z'). --
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access