Required number of characters (1 Viewer)

dogman01

Registered User.
Local time
Today, 00:57
Joined
Dec 3, 2008
Messages
47
How do you make a field in a table require that it has to be exactly 10 characters long when the user inputs text into the field? This is a text field
 

irish634

Registered User.
Local time
Today, 00:57
Joined
Sep 22, 2008
Messages
230
How do you make a field in a table require that it has to be exactly 10 characters long when the user inputs text into the field? This is a text field

In the Validation Rule put this:
Like "??????????"

In the Validation text put something like this:
This text must be exactly 10 characters long
 

RuralGuy

AWF VIP
Local time
, 22:57
Joined
Jul 2, 2005
Messages
13,825
Do your validation in the BeforeUpdate event of the control on the form.
 

Users who are viewing this thread

Top Bottom