combo box shortcut

[NH]

Is there a keyboard shortcut or something which will open a combo box when
in datasheet view?

I rarely use any keyboard shotcuts, but some of my users have said that it
would be easier for them to enter data in datasheet view, but using the
arrow keys to select values from combo boxes.... They would prefer to almost
dispense with the mouse altogether.

Is there already a built-in shortcut, or have I got to use VB?

Thanks

Nick

 

[Sandra Daigle]

The dropdown method of the combo will work in datasheet mode - for example:

Private Sub Combo0_Enter()
Me.Combo0.Dropdown
End Sub

 

[Van T. Dinh]

When the ComboBox has the Focus on a normal Form, Alt + DownArrow will drop
the list down.