Ways of validating data calculate how long youve been dating
This article explains how to use validation rules and validation text in table fields and form controls.A validation rule is one way to restrict input in a table field or a control (such as a text box) on a form.If the rules are mutually exclusive, they prevent you from entering any data at all.For example, suppose you apply the following rule to a date field in a table: Forces users to enter values in the field.Usually, a record validation rule compares the values of two or more fields.Tip: If you create a form automatically from a table by using one of the Form commands on the ribbon, any validation for fields in the underlying table are inherited by the corresponding controls on the form.To add validation rules to a form, you open the form in Layout view and add rules to the properties of individual controls.
Once armed with the intel the exception reports provide, managers and their teams still waste hours (or days) on correcting their data errors and reprocessing affected payrolls.
Typically, your database is easier to use if you use IS NOT NULL and enter a friendly message in the Validation Text property.
You can use wildcard characters in your validation rules.
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.