Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    25

    Unanswered: Want number field to require zero at the start

    Hi there,

    I have a number field that requires 7 digits, the first of which must be a zero.

    I have it coded so that the field requires 7 digits and CAN have a zero as the first digit, but am having trouble coding it so that it MUST have a zero at the start.

    Here is what I currently have for the number field:

    Format: 0000000
    Input Mask: >0000000
    Validation Rule: <=9999999

    I thought by adding and like "0*" to the validation rule it would force the zero at the start, but it's not working.

    any suggestions would be really appreciated,
    thanks!!

  2. #2
    Join Date
    Aug 2008
    Posts
    25
    found the solution by adding quotes around first zero

    Input mask: >"0"000000

Posting Permissions

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