How to Set Not Null in MS Access
Setting a field to NOT NULL in Microsoft Access ensures that it cannot contain empty or null values. Here's how to set this constraint:
- Open your database.
- Go to the 'Navigation Pane' and right-click the table you want to modify. Select 'Design View'.
- Click the field you want to set as NOT NULL.
- In the 'Field Properties' section at the bottom, look for the 'Required' property.
- Click the drop-down arrow and set the 'Required' property to 'Yes'.
- Click the save icon to save your changes.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it