Access combo boxes won't AutoExpand

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?
 
S

SteveS

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?

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
 
G

Guest

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?
 
J

John Vinson

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?

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

John W. Vinson[MVP]
 
B

bob bob via AccessMonster.com

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top