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

[Sue Bricker]

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!

[Mike Turco]

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

[fredg]

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.

[Sean]

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

[Trevor Best]

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]