At table level, I need to REQUIRE that users insert a value that is ONLY 8 characters in length. NO alpha, and not less than 8 or more than 8 (allowing for leading zero’s)
I have “REQUIRED” set to “YES”
I can put : 00000000;;_ as the input mask but an Access MSG is generated and not the validation rule msg.
I can put: Like “????????” in the Validation RULE and all works well. Validation MSG appears if the rule is broken. HOWEVER;
If the user inserts 01234567 Access determines the RULE is broken, when in fact it’s not. 0 is numeric and the total characters is 8.
How can I get past this problem?
