• validation rule to check the number of digits enters

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » validation rule to check the number of digits enters

    Author
    Topic
    #503513

    Hi everyone,

    i want to use validation rule to check how many digits the user is enters in the field, it accept 5 digits not greater than that.

    Regards

    Viewing 1 reply thread
    Author
    Replies
    • #1541105

      You could check to see if it is less than 100,000.

      Group "L" (Linux Mint)
      with Windows 10 running in a remote session on my file server
    • #1541166

      If you want to accept no more than 5 digits, you can use an input mask of “99999”. For exactly 5 digits, use “00000”.

    Viewing 1 reply thread
    Reply To: validation rule to check the number of digits enters

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: