How do I write a validation rule?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tina Campbell
    New Member
    • Apr 2011
    • 1

    How do I write a validation rule?

    how do I write a validation rule to require a 6 digit number in a field?
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    I think that you are actually referring to an Input Mask. To force a User to enter exactly 6 Digits into a Field:
    1. Create the Field in the Table and define it as:
      1. Data Type: TEXT
      2. Field Size: 6
    2. Set the Input Mask Property to: 000000 (6 Zeros)

    Comment

    Working...