Computer and Software Support


Add a validation rule to a table 

Microsoft Access

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. A record validation rule checks input to one or more fields is applied when the focus leaves the record. Usually, a record validation rule compares the values of two or more fields.

Notes:  The following field types do not support validation rules:

  • AutoNumber

  • OLE Object

  • Attachment

  • ReplicationID

 

Go Back

OR

Next Page

You can also

Return to Validation Rule