Combo Box drop down on mouse hover

[khughes46]

Is there a way to get a combo box to drop down when hovering the mouse over the box? I'm in Access 2010. Thanks.

[June7]

I don't think so. Can make it dropdown when the box gets focus.

[ItsMe]

I have never tried it before but there is this ...
https://msdn.microsoft.com/en-us/lib.../ff835703.aspx

I think it would just irritate the user. It seems even less useful than the MouseUp and MouseDown events.

[CJ_London]

It seems even less useful than the MouseUp and MouseDown events.

you haven't lived

the dropdown occurs when you click on the down arrow (so has focus) - but so far as I am aware there is no event you can associate with it

you can mimic the effect you require by having a textbox, a button and a listbox set up to look like a combobox. the button click event (which would make the listbox appear) could be called from the textbox mousemove event

[orange]

@khughes46

Can you describe why you want the drop down to occur with mouse hover? Perhaps there are options to hover and drop down.

[khughes46]

So the user can see the items available for selection without clicking in the dropdown arrow. The dropdown will show even if you roll over the label.

[Missinglinq]

Private Sub ComboName_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
 ComboName.SetFocus
 ComboName.Dropdown
End Sub

Note that if the Combobox is in the Detail Section, on Continuous or Datasheet View Forms, the Combobox of the Record that is currently selected is the one that will dropdown.

Linq ;0)>

[ItsMe]

ComboName_MouseMove

Interesting, this is something I have ignored and was unaware of.

[khughes46]

I'm sure this is what I was Looking for. Thanks.

[June7]

Just tested. As I expected, the control must have focus first. So this does eliminate a click but requires mouse movement. I build forms so user can move through without mouse. So think still need dropdown method code in GotFocus event.

[khughes46]

I got this code from Misslinq above and it works just like I need it to. It's very simple, highlight the combo box, go to Event, click in MouseMove, use the code builder (it starts you out with what you need) the add ComboName.SetFocus ComboName.DropDown and it's done. Finished it looks like:

Private Sub ComboName_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
ComboName.SetFocus
ComboName.Dropdown
End Sub

[Missinglinq]

As I expected, the control must have focus first. So this does eliminate a click but requires mouse movement.

The control doesn't need Focus...that's what the first line of code provides. And, yes, mouse movement is required...you can't do it by telepathy! Eliminating the click needed to cause the dropdown was the object...not eliminating moving the mouse/cursor.

Glad it's working for you, khughes46!

Linq ;0)>

[June7]

Note my following statement: I build forms so user can move through without mouse.

The control must get focus, programmatically or by click or tab into, otherwise the DropDown method will not work. My point is, if user tabs into the combobox, the dropdown will not activate, hence my suggestion to also use the GotFocus event.