Chat with us, powered by LiveChat

Require Data Entry

How to Require Data Entry in Access

Require Data Entry

In Access, you can specify that a field must contain data to prevent users from leaving out important information when they are entering data. For example, at the absolute minimum, a customer record needs to have the customer’s first and last name—otherwise, why bother entering it? You can specify that a field must contain data to prevent users from leaving out important information when they are entering data.

  1. In Design View, click the field you want to require data entry for.
  2. Click the Required box.
  3. Click the Required box list arrow and select Yes.
    Require Data Entry

From now on, if a user tries to add a record without entering a value for this field, Access will display a dialog box stating that the field cannot contain a null value.

FREE Quick Reference

Click to Download