Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2015
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    validation rule to check the number of digits enters

    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

  2. #2
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,647
    Thanks
    478
    Thanked 427 Times in 398 Posts
    You could check to see if it is less than 100,000.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,451
    Thanks
    1
    Thanked 37 Times in 36 Posts
    If you want to accept no more than 5 digits, you can use an input mask of "99999". For exactly 5 digits, use "00000".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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