Creating Validation Rules

Use the Embedded Data Table Editor to create and edit the rules that are used to validate the table data and to create and edit validation error messages.

Use one of the following methods:

In Data view, click the field for which you want to create or edit a rule. On the Fields tab, click Validation, and then click Field Validation Rule or Record Validation Rule. The Edit Validation dialog opens, which you can use to enter an expression to use to validate the data.
In the fields pane of Design view, click the field for which you want to create or edit a rule, and then in the Field Properties pane, click Click to edit Validation Rule. The Edit Validation dialog opens, which you can use to enter an expression to use to validate the field data.

Use one of the following methods:

In Data view, click the field for which you want to create or edit an error message. On the Fields tab, click Validation, and then click Field Validation Rule or Record Validation Rule. The Edit Validation dialog opens. Enter the error message that you want in the Error Message field.
In the fields pane of Design view, click the field for which you want to create or edit an error message, and then enter the message that you want in the Validation Error Message field of the Field Properties pane.
In the fields pane of Design view, click the field for which you want to create or edit an error message, and then in the Field Properties pane, click Click to edit Validation Rule. The Edit Validation dialog opens. Enter the error message that you want in the Error Message field.