469,270 Members | 1,164 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

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



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
4 33925

"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
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
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
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.

Similar topics

reply views Thread by Karl | last post: by
3 posts views Thread by Brian Henry | last post: by
5 posts views Thread by Gil | last post: by
5 posts views Thread by jung_h_park | last post: by
reply views Thread by Andrus | last post: by
2 posts views Thread by Andrus | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.