Microsoft Office Tutorials and References
In Depth Information
Validating Data As It’s Entered
Modifying the lookup list
Adding values to an existing lookup list is pretty easy. If the lookup list
gets its values from a table, just add records to the table to see additional
choices in the lookup list. If you typed values for the lookup list yourself,
switch to Design view, click the field that contains the lookup, and click the
Lookup tab in the field properties (refer to Figure 5-5, earlier in this chapter).
You can add options to the Row Source property; just be sure to separate
the values with semicolons.
Validating Data As It’s Entered
Often, you can formulate a rule that data must pass before being entered
in a certain field. You may know, for example, that the date is not before
1999, that the price is 0 or greater, or that the entry must be five characters
and begin with The Validation Rule field property (in field P.
ties) enables you to specify a rule that data in a single field must pass to
be entered in a particular field. Field validation rules are entered in the
Validation Rule property for the field. Figure 5-7 shows a validation rule
for the Order Date field.
If you just want to require that a value be entered, set the Required field
property to Yes.
You can also specify a validation rule for a record rather than a field. Record
validation allows you to create a rule to prevent internal inconsistency in a
record. You may want to check that the ship date isn’t before the order date,
for example. You can enter record-validation rules in the Validation Rule
property, one of the table properties. Display table properties by clicking
the Property Sheet button on the Design tab (when the Table Design view is
displayed). Figure 5-8 shows a record validation rule.
Figure 5-7:
The Order
Date field
uses a
validation
rule to make
sure that the
date is after
December
31, 2005.
Search JabSto ::




Custom Search