Combo Box Dropdown

  • Thread starter Thread starter Yecenia
  • Start date Start date
Y

Yecenia

Some dropdowns automatically sort to the item you are looking for in the
dropdown when you type in the first letter.

This automatic feature does not always occur. I have toggled between
screens to figure out what the setting difference is between the two. Can
someone help?
 
Some dropdowns automatically sort to the item you are looking for in the
dropdown when you type in the first letter.

This automatic feature does not always occur. I have toggled between
screens to figure out what the setting difference is between the two. Can
someone help?
Click to expand...

Set the combo AutoExpand property to Yes.
It's on the Data tab of the combo properties.
 
fredg said:
Set the combo AutoExpand property to Yes.
It's on the Data tab of the combo properties.
Click to expand...

The setting was "Yes" under Auto Expand. I just removed the dropdown from
the form and dragged it back. I guess it needed to be refreshed. The
settings were exactly the same and it works now.

-Thanks.
 
Fred,
I have refreshed the dropdown and even created it from scratch. The
refreshing strategy only worked for one drop down by not for the others that
don't work.

Regardless of the setting it will not automatically find the data in the
dropdown when its typed.

The look up tables is a list of countries. There is about 280 items
(countries) in the list. Does the automatic search not work when there are
too many items in the dropdown? Please help!
 
Fred,
I have refreshed the dropdown and even created it from scratch. The
refreshing strategy only worked for one drop down by not for the others that
don't work.

Regardless of the setting it will not automatically find the data in the
dropdown when its typed.

The look up tables is a list of countries. There is about 280 items
(countries) in the list. Does the automatic search not work when there are
too many items in the dropdown? Please help!
Click to expand...

The maximum number of items in a combo row source is 65000+, so you
are nowhere near the limit of items.

Perhaps try deleting completely the combo box. Save the change and
close the database.
Then create a new database and import everything into it from this
current database including the form (without the combo box) by
clicking on
File + Get External Data + Import
Then create a new combo box. Make sure it's AutoExpand property is
Yes.
Without seeing your set up I am unable to offer anything else.
 
Back
Top