Opening Combobox Dropdowns in QBE design view via Keyboard (1 Viewer)

sxschech

Registered User.
Local time
Yesterday, 18:09
Joined
Mar 2, 2010
Messages
791
In earlier versions of access the F4 key would open a drop down in both Normal view and design view. Unfortunately in newer versions such as 2013, the F4 key opens the Property Sheet when in design view. Have been searching periodically over the years to locate a keyboard shortcut replacement for this. Finally found it yesterday. It's not as convenient because requires two keys, but still could be of use rather than having to switch between keyboard and mouse. I frequently had used it to select the table/query when there were more than one, particularly if the names began with the same letters and could not see the name without expanding the width of the grid.

In the documentation, they don't specifically mention the use case I sought, but I gave it a try and it worked.

To get the same effect as F4 when in design mode, use Alt+Down Arrow.

This also works in design view of Forms.

https://support.office.com/en-us/ar...4-4f7b-4300-b8e5-3320fa6606e2#bkk_workdldview

Documentations mention
Show or hide the property sheet

F4

Open a combo box

F4 or Alt+Down arrow
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:09
Joined
Oct 29, 2018
Messages
21,358
Hi. Thanks for the tip.
 

Users who are viewing this thread

Top Bottom