Microsoft Office Tutorials and References
In Depth Information
Validation Rules AC 167
To Specify a Default Value
To specify a default value, enter the value in the Default Value property box. The following step specifi es
MED as the default value for the Client Type fi eld. This simply means that if users do not enter a client type, the
type will be MED.
1
Select the Client Type fi eld. Click
the Default Value property box
to produce an insertion point,
and then type =MED as the value
(Figure 3–35).
Client Type
fi eld selected
default value
Figure 3–35
To Specify a Collection of Allowable Values
The only allowable values for the Client Type fi eld are MED, DNT, and LAB. An appropriate validation
rule for this fi eld prevents Access from accepting any entry other than these three possibilities. The following step
specifi es the legal values for the Client Type fi eld.
1
Make sure the Client Type fi eld is
selected.
Click the Validation Rule property
box to produce an insertion point
and then type =MED or =DNT or
=LAB as the validation rule.
Client Type
fi eld selected
Click the Validation Text property
box and then type Must be MED,
DNT, or LAB as the validation
text (Figure 3–36).
quotation marks added
automatically by Access
Validation Rule
What is the effect of this change?
Users now will be allowed to
enter only MED, DNT, or LAB in
the Client Type fi eld when they
add records or make changes to
this fi eld.
Validation Text
Figure 3–36
 
Search JabSto ::




Custom Search