O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Validating Data Entry

Some categories of data, such as credit limits or the date someone joined a club, have to meet certain criteria. You can make sure data entered into fields meets those criteria (for example, all credit limits are $5,000 or less) by performing data validation. When a user tries to enter data that isn’t appropriate for the field, you can display a message letting the user know what went wrong.

Perform Data Validation

  1. Open a table in Design view.

  2. Click the field for which you want to validate data entry.

  3. Click Validation Rule.

  4. Click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required