Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo box doesn't select matching text items

Status
Not open for further replies.

v5652

Programmer
Mar 19, 2008
76
IN
Hi,

I have an issue with database created in MS Access 2016 version.
When I type any text in the combobox it doesn't show the items in the list.
Even Auto Expand property is also selected as Yes.
But if I use it my older database MS Access 2007 it works perfectly.

Is there any solution for this issue?
Thanks.
 
 https://files.engineering.com/getfile.aspx?folder=199e2390-6331-4c42-951f-2b81c37264ab&file=ComboBox_issue_no_1.png
Can you manually select a value?
Have you tried creating a new combo box on a test form?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Hi,

I tested it by creating new combo box but sometimes it works sometimes doesn't.
Is there any setting due to which this problem comes?
Because when I use it with MS Access 2007 database it works perfectly.
but when I use the MS Access 2016 database it doesn't work.
All coding is same in both the databases.
 
So, this does work sometimes in 2016? Are you using the same table/query for the row sources? Are you testing on a new, unbound form?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top