Solved

Access 2010 dropdown menus - combo boxes

Posted on 2013-11-18
2
304 Views
Last Modified: 2013-11-20
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
Comment
Question by:msmerry
2 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 39656368
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
 

Author Closing Comment

by:msmerry
ID: 39664498
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Query to summarise data Like Pivot Table 3 29
Excess tables to Excel BackUp 3 28
email about the whoisactive result 7 23
Update data using formula 22 20
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now