We help IT Professionals succeed at work.

Quick question about Access 1020 Combo Box display

Megin
Megin asked
on
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?
Comment
Watch Question

Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
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.

=YourCombBoxName.Column(N)

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.

mx

Author

Commented:
That worked beautifully!  Thank you!!!
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
You ... are welcome ...

Explore More ContentExplore courses, solutions, and other research materials related to this topic.