Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Validation Rule (A2K)

    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?
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Validation Rule (A2K)

    I tried it and it appeared to work correctly. Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Validation Rule (A2K)

    <P ID="nt"><font size=-1>(No Text)</font>
    Attached Files Attached Files
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Validation Rule (A2K)

    If you want to keep leading zeros, you must use a text field, not a number field. If you enter 01234567 in a number field, Access will store the value 1234567.

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Validation Rule (A2K)

    Thanks Hans,
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •