How to Change Drop-Down Box Access

Microsoft Access is a program that stores data in fields and records. These fields and records are kept inside database tables, which can be acted upon by assorted Access objects. Among these objects are queries and forms, which are used to search the database. If a form becomes too complex or has too many options, a solution may be to use a drop-down box. After the drop-down box has been created, it is possible to change it in the form's "Design View."

Step

Double-click the Access database file to open the database in Microsoft Access.

Step

Select the "Forms" option under the "Objects" column on the left side of the screen.

Step

Double-click the form that contains the drop-down box you intend to change.

Step

Right-click on the form name at the top of the window and select the "Design View" option.

Step

Right-click on the drop-down menu and choose the "Properties" option.

Step

Click the "Format" tab at the top of the window and adjust the values in the fields that you wish to change. The changes on this tab will affect the appearance of your drop-down menu.

Step

Select the "Data" tab at the top of the window and adjust the values in the fields that you wish to change. Any changes to the fields on this tab will affect the data source for your drop-down menu.

Step

Save your changes to the form and close the form window. The next time that the form is opened, your drop-down box changes will have been applied.