Hi - anyone know how to get a drop down list combo box to allow you to select an option using the up/down arrows on the keyboard in access rather than having to click on the down arrow on the combo box in access - user wants to do it by tabbing into boxes and using the arrows to select because its quicker.
thanks,
Rhys.
Using arrows to select in drop down list in access
Chimme
Hi Andy, thanks that helps but i would like users to just be able to use the down arrow and not use alt just to make it easier to use and i know that is how they will want to do it (why are end users so fussy! ). I notice there is an 'on down' event - i assume that this could be used to achieve my aim - would you know what code to enter to enable my users to work in this way
Many thanks,
Rhys.
Rafet
To display the dropdown part use ALT+Down
Andy Ho
Try this, dropdown appears on down arrow. Test also allows normal use of ALT+Down
Private Sub ComboBox1_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyDown And Shift <> acAltMask Then
ComboBox1.Dropdown
End If
End Sub
Steven R
Cheers andy - thats perfect!
Rhys.