Validation rules for certain fields, Cheat Sheet of Computer Science

Validation Rules for fields

When you select a field in table design, you see itsValidation Ruleproperty in thelower

pane.

This rule is applied when you enter data into the field. You cannot tab to the next field until

you enter something that satisfies the rule, or undo your entry.

To do

this ...

Validation

Like "*[!a-z]*"

insensitive.)

Accept digits

(0 - 9) only

Is Null OR Not

Like "*[!0-9]*"

Any character outside the range 0 to 9 is rejected. (Decimal

point and negative sign rejected.)

Letters and

spaces only

Is Null Or Not

Like "*[!a-z OR

"" ""]*"

Punctuation and digits rejected.

Digits and

letters only

Accepts A to Z and 0 to 9, but no punctuation or other

characters.

digits

Is Null OR

Between 1000

And 9999

For Number fields.

Is Null OR Like

"####" For Text fields.

Positive

numbers only

Is Null OR >=

No more

than 100%

100% is 1. Use 0 instead of -1 if negative percentages are

not allowed.

address

Is Null OR

((Like "*?@?*.?

*") AND

 (Not Like

"*[ ,;]*"))

Requires at least one character, @, at least one character,

dot, at least one character. Space, comma, and semicolon

are not permitted.

You must fill

inField1 Not Null Same as setting the field'sRequiredproperty, but lets you

create a custom message (in theValidation Textproperty.)

Limit to

specific

Is Null OR "M"

Or "F"

It is better to use a lookup table for the list, but this may be

useful for simple choices such as Male/Female.