Validation Rule for number of characters (Loe Asked)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a text-box for inputing check-no on my form. This Check no must be in
6 digits.
So I put "999999" in input mask , but the validation rule of "Len(ID) =6"
doesn not work for the check no is being just entered.
Would anyone know how to enforce user to input a 6 digit number (neither
lesser or more than 6) in a text-box??!
 
Leo said:
Hi,
I have a text-box for inputing check-no on my form. This Check no
must be in 6 digits.
So I put "999999" in input mask , but the validation rule of "Len(ID)
=6" doesn not work for the check no is being just entered.
Would anyone know how to enforce user to input a 6 digit number
(neither lesser or more than 6) in a text-box??!
Click to expand...

Try a validation rule of

Like "######"

Or wouldn't a input mask of

000000;;_

do? But unless you do validation rule on table level and set the
required property, or catch it in the forms before update event, I
dont' think you'll prevent Null.
 
Back
Top