How to hide the combo box drop-down arrow on a form in Access
Original KB number: 325233
Note
Requires knowledge of the user interface on single-user computers.This article applies to a Microsoft Access database (.mdb and .accdb) and to a Microsoft Access project (.adp).
This article demonstrates a method that you can use to hide the drop-down arrow on a combo box until the combo box is selected.
Steps to hide the drop-down arrow on a combo box
To hide the drop-down arrow on a combo box when the combo box is not selected, follow these steps:
- Start Access.
- On the Help menu, point to Sample Databases, and then click Northwind Sample Access Database.
- Open the Orders form in Design view.
- Add a rectangle control to the form. Size and move the rectangle control so that it completely covers the drop-down arrow on the EmployeeID combo box.
- Set the
BackColor
property of the rectangle to match theBackColor
property of the section. - Set the
BackStyle
property to Normal. - Set the
BorderStyle
to Transparent. - View the form in Form view.
Notice that you can see the drop-down arrow on the EmployeeID combo box only when the combo box is selected.
References
For more information about BackColor, BackStyle, or BorderStyle properties, click Microsoft Access Help on the Helpmenu, type BackColor, BackStyle, BorderStyle, or Windows color scheme in the Office Assistant or the Answer Wizard, and then click Search to view the topic.