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
Solved

combobox autoexpand strange behavior

Posted on 2006-11-17
1
353 Views
Last Modified: 2008-02-01
I have a combobox whose rowsource is: select last & ", " & first from mailingList, and autoexpand is True.
I have a person in the mailingList with last = "I" and first = "P".
When I type 'i' in the combobox I, P appears (as expected), but then the insertion point jumps to just past the I and autoexpand does not respond as expected to entry of a 2nd last name letter. Any thoughts?
0
Comment
Question by:ramrom
1 Comment
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 125 total points
ID: 17970495
Try using the keyword "Distinct" as discussed in this link:

         select DISTINCT last & ", " & first from mailingList

             http://support.microsoft.com/kb/824189
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

791 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