Validation rules

  • Thread starter Thread starter JaneM
  • Start date Start date
J

JaneM

I have a job number field in which I would like to prevent typographical
errors.
Some one has suggested that I use validation rules. Can some one give
me a sample? Thanks in advance.

Field: Job number
 
If you open the table in design view and select your field, in the lower part
of the window you will see the "field properties". This is where you will find
the validation rule property.

As far as an example of what you should put there, that would be difficult to
say since we don't have any idea what your *rule* is. You can find some
examples in your Access help file if you search for validation rule, or you
can
post back with more specifics about exactly what you want your job number
field to be limited to, an I'm sure someone can help you.
 
If it's a numeric field you could use <=9999. This will accept any 1,2,3 or 4
digit number. If it's acceptable for the field to be null (empty) then use;
Is Null Or <=9999.
 
Jane,

If you can define what a "typo" would mean, then we would be a long way
along the track.

When you say "4 spaces" I assume you mean 4 *characters*, right?

Maybve some examples of valid and invalid job numbers would help.

If you can't define it, then the computer won't be able to either!
 
Back
Top