Use cbo without a mouse

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

hi - have cbo boxes on my forms- when i tab to the cbo box , i must click
with the mouse to
get the selections to display...
i was told that to meet requirements for accessibility, the cbo must be able
to display the list without the use of the mouse...
so, how is that accomplished/should that be done with keyboard strokes? or
vba?
thanks
 
In the On Got Focus event of your Combo Box, insert the following code:

Me!MyComboBox.Dropdown

As soon as a user tabs into the Combo Box or presses Enter to move from the
current field to that Combo Box, the list will open.

Also, in your Combo Box, you can set the AutoExpand property to 'Yes', which
will allow Access to display automatically the first underlying value that
matches the character(s) entered from the keyboard.
 
If your combo box is cboTest then
in form design mode click View > Code.....

Private Sub cboTest_GotFocus()
cboTest.Dropdown
End Sub
 
Junior said:
hi - have cbo boxes on my forms- when i tab to the cbo box , i must click
with the mouse to
get the selections to display...
i was told that to meet requirements for accessibility, the cbo must be able
to display the list without the use of the mouse...
so, how is that accomplished/should that be done with keyboard strokes? or
vba?
Click to expand...


The keyboard shortcut is Alt+DownArrow
 
i was told that to meet requirements for accessibility, the cbo must
to display the list without the use of the mouse...
Click to expand...

After you tab to the cbo, press the [F4] key to drop
down the list. Use the [up] and [down] arrow keys to
move through the list.

(david)
 
Back
Top