?
Solved

Access 2010 dropdown menus - combo boxes

Posted on 2013-11-18
2
Medium Priority
?
310 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 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

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Suggested Courses

800 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