combo box shortcut

  • Thread starter Thread starter NH
  • Start date Start date
N

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
 
The dropdown method of the combo will work in datasheet mode - for example:

Private Sub Combo0_Enter()
Me.Combo0.Dropdown
End Sub
 
When the ComboBox has the Focus on a normal Form, Alt + DownArrow will drop
the list down.
 
Back
Top