Numeric Data Entry

[rciolkosz]

What do I put in the validatation rule to assure that only 9 digits are
entered. Validation test would say "you can only enter 9 digits in this
field"

 

[Tom van Stiphout]

On Sun, 3 Jan 2010 11:07:01 -0800, rciolkosz

In table design view, select the field and for the Validation Rule
enter:
Between 100000000 And 999999999
I'm sure you can do the Validation Text yourself.

-Tom.
Microsoft Access MVP

 

[Guest]

What do I put in the validatation rule to assure that only 9 digits are
entered. Validation test would say "you can only enter 9 digits in this
field"

 

[John W. Vinson]

What do I put in the validatation rule to assure that only 9 digits are
entered. Validation test would say "you can only enter 9 digits in this
field"

A validation rule

LIKE "#########"

will do the job.

 

[å¼ å°å»º]

What do I put in the validatation rule to assure that only 9 digits are
entered. Validation test would say "you can only enter 9 digits in this
field"

 

[å¼ å°å»º]

What do I put in the validatation rule to assure that only 9 digits are
entered. Validation test would say "you can only enter 9 digits in this
field"

 

[ÕÅС½¨]

What do I put in the validatation rule to assure that only 9 digits are
entered. Validation test would say "you can only enter 9 digits in this
field"

 

[å¼ å°å»º]