D dogman01 Registered User. Local time Today, 17:08 Joined Dec 3, 2008 Messages 47 Jan 21, 2009 #1 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
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
I irish634 Registered User. Local time Today, 17:08 Joined Sep 22, 2008 Messages 230 Jan 21, 2009 #2 dogman01 said: 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 Click to expand... In the Validation Rule put this: Like "??????????" In the Validation text put something like this: This text must be exactly 10 characters long
dogman01 said: 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 Click to expand... 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 Today, 15:08 Joined Jul 2, 2005 Messages 13,825 Jan 21, 2009 #3 Do your validation in the BeforeUpdate event of the control on the form.
