How to Create Combo Box Validation MS Access

Quick summary

This tutorial shows how to create combo box validation in Microsoft Access by enabling the Limit to List property, which restricts users to selecting only predefined values and prevents invalid data entry in your forms.

Steps

1. Open your form in Design View.
2. Go to the Controls group and select the Combo Box control.
3. In the Property Sheet, navigate to the Data tab and locate the Limit to List setting.
4. Set Limit to List to Yes to prevent users from entering values not in the list.
5. Click the save icon to save your changes.