• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Access 2010 dropdown menus - combo boxes

I use combo boxes often, but am confused as to why some work well and others don't.

Sometimes, I start typing the text I want, and the list automatically finds the relevant entry; other times, the list is there, but I have to scroll down to find what I want.
For instance, on one menu, I type j and it moves immediately to the first J- jamc; as I continue typing, it moves to the relevant entry - jond.  I can see this happening, I don't need to pull down the list.  This means I don't have to know the exact spelling, or do a long scroll dowm
In other places, I have to know exactly what I need to type, or scroll down till I find it.

Does that make sense?
0
msmerry
Asked:
msmerry
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Have you set AutoExpand and LimitToList to Yes? That's the most common cause.

If you have, and if the combos still aren't behaving correctly, then you may need to perform maintenance on the database. Make a backup, then try to Compact the database. If that doesn't work, try to decompile it

Decompile: Create a shortcut with this as the Target: "Full path to msaccess.exe" "Full patth to your db" /decompile

Run that, then compact again.

You might also consider moving everything over to a new, blank database.

Also be sure your machine is fully up to date regarding Office and Windows updates.

If none of those work, try removing and re-inserting your combos.
0
 
msmerryAuthor Commented:
Have you set AutoExpand and LimitToList to Yes? Checked and found most had AutoExpand Yes, Limit to List No; set both to Yes- no change, set both to No - no change.
Made the backup, compacted it - and it worked!  I have no idea what changed, but then I guess that's what Compact and Repair is for.
Just goes to prove you shouldn't work too late into the night or you overlook the obvious.

Thank you, LMS Consulting.  Once again Experts Exchange to the rescue.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now