# How to Set Not Null in MS Access

> To set Not Null in MS Access, open your database, right-click the table in the Navigation Pane, and select Design View. Click the target field, locate the Required property in the Field Properties section, set it to Yes using the drop-down arrow, and click the save icon.

Canonical: https://livedemo.ai/tutorials/how-to-set-not-null-in-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a4dc0ab56e05a00ff96c3/preview?step=1

## Steps

1. Open your database.
2. Go to the 'Navigation Pane' and right-click the table you want to modify. Select 'Design View'.
3. Click the field you want to set as NOT NULL.
4. In the 'Field Properties' section at the bottom, look for the 'Required' property.
5. Click the drop-down arrow and set the 'Required' property to 'Yes'.
6. Click the save icon to save your changes.