Solved

Access 2010 dropdown menus - combo boxes

Posted on 2013-11-18
2
305 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

789 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