RhysDavies


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.




Re: Using arrows to select in drop down list in access

Andy Pope


Hi,

To display the dropdown part use ALT+Down






Re: Using arrows to select in drop down list in access

RhysDavies

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.






Re: Using arrows to select in drop down list in access

Andy Pope

Fussy users, surely not.

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






Re: Using arrows to select in drop down list in access

RhysDavies

Cheers andy - thats perfect!

Rhys.