Solved

Access 2010 dropdown menus - combo boxes

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

749 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