How to Add List Box MS Access

Quick summary

A List Box in MS Access lets users select values from a predefined list directly on a form, reducing data entry errors. This tutorial walks through using the List Box Wizard in Form Design to add, configure, and test the control step by step.

Steps

1. Go to the Create tab in MS Access.
2. On the Create tab, select Form Design.
3. On the Form Design tab in the ribbon, go to the Controls group and click on the List Box tool.
4. The List Box Wizard will automatically open to guide you through configuring the list box.
5. Choose how the list box gets its values.
6. Sort the order for the items in your list box and click Next.
7. Drag to adjust the width of a column and click Next.
8. After the wizard completes, click Finish and the list box will appear on your form.
9. Switch to Form View to test the list box.