Code to expand/collapse combo box drop-down list

[Graham Walker]

Does anyone know code to automatically expand a combo box list when the
control receives the focus and collapses it when the focus is lost?

Thanks

 

[Arvin Meyer [MVP]]

In the Enter event, or GotFocus event use:

Me.ComboBoxName.Dropdown

When you exit the combo box control the list will retract.

 

[Graham Walker]

Thank you Arvin for your quick reply. I just used your code and it works
like a charm.

Thank you again.