By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,364 Members | 1,518 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,364 IT Pros & Developers. It's quick & easy.

How to open up combobox dropdown with keys (not mouse)

P: n/a


Greetings. In Access, is there a way to open up a drop-down combobox
with keys on the keyboard, instead of using the mouse to click on the
down arrow of the combobox? I really prefer to use the arrows on the
keyboard and the enter key to make my selection. But if I have to click
on the down arrow of the combobox then I might as well use the mouse
pointer to make my selection.

Just curious.

Thanks.
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a

"Sue Bricker" <sb****@att.net> wrote in message
news:42**********@127.0.0.1...


Greetings. In Access, is there a way to open up a drop-down combobox
with keys on the keyboard, instead of using the mouse to click on the
down arrow of the combobox?

I believe you hold the ALT and press down-arrow.
Nov 13 '05 #2

P: n/a
On 17 Mar 2005 13:29:45 -0600, Sue Bricker wrote:
Greetings. In Access, is there a way to open up a drop-down combobox
with keys on the keyboard, instead of using the mouse to click on the
down arrow of the combobox? I really prefer to use the arrows on the
keyboard and the enter key to make my selection. But if I have to click
on the down arrow of the combobox then I might as well use the mouse
pointer to make my selection.

Just curious.

Thanks.
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Beside Alt + Down Arrow you could have the combo box drop down upon
entry.
Code the Combo's Enter event:

Me![ComboName].Dropdown
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #3

P: n/a
Another way to open a drop down is to hit F4 manually or, if you want
to simulate this dynamically using VBA, do :

Sendkeys "{F4}", true

in code...

Nov 13 '05 #4

P: n/a
Sean wrote:
Another way to open a drop down is to hit F4 manually or, if you want
to simulate this dynamically using VBA, do :

Sendkeys "{F4}", true

in code...


Stick with the .Dropdown method in code. Sendkeys is not safe, there is
no guarantee that the keys sent will go to the application they are
supposed to go to.

--
[Oo=w=oO]

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.