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."
Double-click the Access database file to open the database in Microsoft Access.
Select the "Forms" option under the "Objects" column on the left side of the screen.
Double-click the form that contains the drop-down box you intend to change.
Right-click on the form name at the top of the window and select the "Design View" option.
Right-click on the drop-down menu and choose the "Properties" option.
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.
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.
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.
Tips & Warnings
- Add a drop-down box to your Access form by clicking the "Wizard" option from the top of the toolbar, then selecting the "Combo Box" option. Follow the prompts from the wizard to customize the data source and appearance of your drop-down box.