Order of validation for controls and fields

Microsoft Office Access 2003

previous page next page

Show All Show All

Order of validation for controls and fields

Validation rules for controls and fields are evaluated in the following order:

  1. Macro or event procedure validation (for example, a macro or an event procedure that responds to the BeforeUpdate event of the control or the form containing the control)
  2. The control's ValidationRule property
  3. The underlying table's validation rules for the field (as set in the field's ValidationRule, Required, and AllowZeroLength properties)
  4. The underlying table's ValidationRule property (this property performs validation on records)
previous page start next page