User manual

Setting options for fields | 95
7. Select validation options for the field.
To require that the entered value Select
Contains only numbers Strict data type, then choose Numeric Only from
the list
Is a date containing numeric values for the
month and day, and four digits for the year
(for example, 5/12/2010)
Strict data type, then choose 4-Digit Year Date
from the list
Is a time containing numeric values for
hours and minutes between 00:00 and
23:59 (seconds are optional)
Strict data type, then choose Time of Day from
the list
Is not blank Not empty
Does not duplicate a value found in this
field in other records
Unique value
Matches another value in the same field in
any other record
Existing value
Matches a value in a specified value list Member of value list, then choose an existing
value list or define a new one
Is within a specific range of letters,
numbers, dates, or times
In range, then type the beginning and ending
values
Matches the result of a calculation Validated by calculation, then enter a calculation
in the Specify Calculation dialog box. Select or
clear Validate only if field has been modified.
Then click OK.
The result must be Boolean—true or false. The
result is true when the result is any number
except zero; any other result (zero, no data, or
non-numeric data) is false.
For more information about the Specify
Calculation dialog box, see
“Defining
calculation fields” on page 85.
Does not exceed the specified number of
characters
Maximum number of characters, then type the
maximum number of characters allowed
φμπ10_υσερσ_γυιδε.βοοκ Παγε 95 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ