Use cbo without a mouse

[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

 

[Cheryl Fischer]

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.

 

[jmonty]

If your combo box is cboTest then
in form design mode click View > Code.....

Private Sub cboTest_GotFocus()
cboTest.Dropdown
End Sub

 

[Marshall Barton]

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?

The keyboard shortcut is Alt+DownArrow

 

[Junior]

thanks everyone

 

[david epsom dot com dot au]

i was told that to meet requirements for accessibility, the cbo must

to display the list without the use of the mouse...

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)