Numeric Data Entry

R

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"
 
T

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
 
G

Guest

rciolkosz said:
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"
 
J

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.
 
Å

å¼ å°å»º

rciolkosz said:
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"
 
Å

å¼ å°å»º

rciolkosz said:
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"
 
Õ

ÕÅС½¨

rciolkosz said:
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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top