Search code examples
ms-accessformscomboboxms-access-2003

How can I make Access combo boxes unfurl on arrow key down?

With combo box controls, I'm used to being able tab to them, click the down arrow key to open up the options, and then use the up and down arrow keys to navigate those options. In an Access form I've designed, pressing down while a combo box is active moves to the next control. I already have tab for that, so how can I get the down arrow to behave as I expect?

These combo boxes are the only thing between me and a mouse-free form, which I consider essential for data entry.

Solution

  • In the event for KeyDown, you can check if the down arrow was pressed, and if it was, you can execute the following

    ComboBox1.Dropdown