Access combo boxes won't AutoExpand

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

Guest

My application has two main forms, with 16 combo boxes. None of the combo
boxes will Auto-Expand, and I desperately need the time savings of this
feature.

All the individual property sheets show AutoExpand is "Yes."

I've searched Tools > Options, and can't find any "global" setting that
might override this capability.

Suggestions?
 
PeteM-CA said:
My application has two main forms, with 16 combo boxes. None of the combo
boxes will Auto-Expand, and I desperately need the time savings of this
feature.

All the individual property sheets show AutoExpand is "Yes."

I've searched Tools > Options, and can't find any "global" setting that
might override this capability.

Suggestions?
Click to expand...

Auto expand is when the combo box has focus and you start typing, it
automatically takes you to that item, ie if you type a "S", the combo
box displays the top of the S's. If you then type a "M", if Smith is the
only item that begins with "Sm", then Smith is displayed in the combo
box. All you have to do is hit enter, without typing the "ith".

If you want the combo box to dropdown when it has the focus, for each
combo box, open properties, click on the EVENT tab and click in the "On
Got Focus" line. Click on the ellipsis (the 3 dots on the right).

Add one line of VB; if the combo box is named combo4, it should look
like this:

Private Sub Combo4_GotFocus()
Me.Combo4.Dropdown
End Sub


Change Combo4 to the name of your combo box.

Do this for each combo box you want to automagically 'dropdown'.

HTH
 
Thanks, SteveS. The auto dropdown is s good tip which I may use elsewhere,
but my problem in this case is with the basic functionality of the widget.
It should be working exactly as you describe, but as I type in letters, it
doesn't start matching. It seems like a bug or something where I have an
inadvertent feature turned off. Anyone else out there ever run across this?
 
Thanks, SteveS. The auto dropdown is s good tip which I may use elsewhere,
but my problem in this case is with the basic functionality of the widget.
It should be working exactly as you describe, but as I type in letters, it
doesn't start matching. It seems like a bug or something where I have an
inadvertent feature turned off. Anyone else out there ever run across this?
Click to expand...

Check to make sure that Limit to List is turned on. IIRC autocomplete
won't work if it's not.

John W. Vinson[MVP]
 
Two suggestions:
First, be sure you have the most recent service pack installed.
Second, be sure you have the "list rows" property set to a number that
matches the number of items in the combo box list. If it's set to 1, the
box won't expand.
 
Back
Top