Quick question about Access 1020 Combo Box display

Posted on 2012-08-16
Last Modified: 2012-08-16
Here is an illustration of what I am talking about.This question doesn't involve any code (yet).

I have a combo box in my Access 2010 database form. It has two columns in it. When I click on the arrow to see the drop-down list, I can see both of the columns. However, once I choose the item from the list that I want, the box only displays the first item in the column.

How to I make it so that both items show when I am not looking at the whole list?
Question by:Megin
    LVL 75

    Accepted Solution

    That is the expected behavior of the combo box ... it will only show the first non-zero width column.
    So, two ways around this .... you can concatenate two columns together in the Row Source, or ... put a Text box say next to the combo, with a Control Source expression that references the column in the combo you also want to display, like so.


    Where N is the Number, minus 1 ... of the physical column you want to display.  The Column() property is Zero Based.  So, Column(3) is physical Column 4.  Column(2) is physical column 3 ... and so on.


    Author Comment

    That worked beautifully!  Thank you!!!
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    You ... are welcome ...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now