Drop down arrow

[Wuelf]

Hi,
Could someone please explain how in a drop down box I can code the down
arrow that it opens the drop down box then reverts back to a normal down
arrow ??

Thanks in advance

 

[Michel Walsh]

Hi,


Me.ComboBoxName.DropDown


at least, it works in the most recent Access versions.


Hoping it may help,
Vanderghast, Access MVP

 

[Wuelf]

Hi Michel,

Thanks for that but it wasn't what I was looking for.
What i need is once you have entered a combo box you can just hit the down
arrow button as opposed to using Alt - Down arrow to open/expand the list
any suggestions?

 

[Douglas J. Steele]

In the combo's KeyDown event, put code like:

Private Sub ComboBoxName_KeyDown(KeyCode As Integer, Shift As Integer)

If KeyCode = vbKeyDown Then
Me.ComboBoxName.Dropdown
End If

End Sub