Resident validating data entry form

19-Nov-2015 01:00

A validation rule limits or controls what users can enter in a table field or a control (such as a text box) on a form.

To add validation rules to a table, you open the table in Design view and set various table properties.Some of those features, such as data types, become part of your database by default, but you can use other techniques, such as field properties, validation rules, and input masks, at your discretion.This article explains how to use the Validation Text and Validation Rule properties in table fields, queries, and form controls.For more information about input masks, see the article Create an input mask to enter field or control values in a specific format.

You can define validation rules for tables and for controls on forms.To add validation rules to a form, you open the form in Design view and add rules to the properties of individual controls.