access combo box list without using mouse

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box - the user doesn't want to have to take her keys off the
keyboard to click the drop-down arrow. She wants to be able to just enter the
box & have it open & be able to use the arrow down keys to make her
selection. Is there a way to do this?

Our other thought was the way drop-down boxes work on web pages where like
you would need to choose Oregon & if you just keep hitting O, you eventually
get to Oregon. Is there a way to make Access combo boxes do that?
 
How about using the Enter event of the combo to fire its DropDown method:
Private Sub combo1_Enter()
Me.combo1.DropDown
End Sub
 
I have a combo box - the user doesn't want to have to take her keys off the
keyboard to click the drop-down arrow. She wants to be able to just enter the
box & have it open & be able to use the arrow down keys to make her
selection. Is there a way to do this?

Our other thought was the way drop-down boxes work on web pages where like
you would need to choose Oregon & if you just keep hitting O, you eventually
get to Oregon. Is there a way to make Access combo boxes do that?
Click to expand...

You can do BETTER. If the first visible field in the combo is the
state name, for instance; and if it's alphabetically sorted, you can
tab into the field, type OR and it will be at Oregon. O will jump to
the first row starting in O; R will go to the first row starting with
OR, and so on.

I very rarely use the mouse with combos - autocomplete is very
effective in many cases.

John W. Vinson[MVP]
 
Donna,

For the functionality that John mentioned to work, the Auto Expand
property of the combobox has to be set to Yes.

Another option is that the F4 key will cause the combobox list to
drop-down, and then the Down Arrow to scroll to the item you want to select.
 
I've got an AutoComplete problem relating to keying in information, and for
clarity I'll use this example.

Say I'm using the state example and I wanted to enter the state of Oregon
into a field. When I enter the field and type the first letter of the state,
O, the field immediately fills the field with the first record it sees that
matches O, Ohio. It does not keep the "hio" highlighted so you can continue
typing, but you must delete the extra letters manually and then type in
"regon". The Event Procedures for this box are for OnUpdate and On Entry not
in list, and the code in those events don't appear to have any auto complete
commands in them. Auto expand is set to yes. I've used other databases
where this isn't a problem, what is the fix?
 
She can tab to the combo box, and use the [alt+down arrow] combination to
open up the combo box, or to select the next entry down form the entry that
is selected as part of the autoselect action when she keys in the first
letter.
 
I have used the below methodology to display the combo box drop down
automatically when a user enters the field. Thanks so much Allen! It works
like a charm.

But it seems that the combo box drop down stays open even after a selection
is made from the list.

I would like to use the After Update event to close the DropDown view. Does
anyone know if this is possible?

Thank you,

Nicole
 
Back
Top