Validating microsoft office

Expressions can also perform mathematical operations. For example, the expression You can add a field validation rule and/or a record validation rule.A field validation rule checks input to a field, and is applied when the focus leaves the field.For example, suppose you apply the following rule to a date field in a table: Forces users to enter values in the field.

To add validation rules to a table, you open the table and use commands on the Fields tab of the ribbon.

To add validation rules to a form, you open the form in Layout view and add rules to the properties of individual controls.

You can define validation rules for table fields and for controls on forms.

When you define rules for tables, those rules apply when you import data.

You can use wildcard characters in your validation rules.