Create A Validation Rule To Validate Data In A Field

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. Microsoft Office Access 2007 provides a number of ways to validate data, and you often use several of those techniques to define a validation rule. This paper explains how to add validation rules to a database. Validation rules restrict what users can enter in a given field, and also help ensure that your database users enter the proper types or amounts of data.