Microsoft Office Tutorials and References
In Depth Information
Field Properties for Making Sure That Data Entries Are Accurate
the time because the default value appears already in each record when you
enter it. You can always override the default value by entering something
As long as you know your way around operators and Boolean expressions,
you can establish a rule for entering data in a field. For example, you can
enter an expression that requires dates to be entered in a certain time frame.
Or you can require currency figures to be above or below a certain value.
To establish a validation rule, enter an expression in the Validation Rule text
box. To use dates in an expression, the dates must be enclosed by number
signs (#). Here are some examples of validation rules:
The value you enter must be over 1000.
The value you enter must be under 1000.
The value you enter must be greater than or
equal to ten.
The value you enter cannot be zero.
The date you enter must be January 1, 2013,
>=#1/1/2012# And <#1/1/2013#
The date you enter must be in the year 2012.
To get help forming expressions, click the three dots beside the Validation
Rule text box to open the Expression Builder, as shown in Figure 2-6, and
build an expression there. Try clicking the Help button in the Expression
Builder dialog box. Doing so opens the Access Help program, where you can
get advice about building expressions.