• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 521
  • Last Modified:

Quick question about Access 1020 Combo Box display

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?
  • 2
1 Solution
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)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.


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.

MeginAuthor Commented:
That worked beautifully!  Thank you!!!
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You ... are welcome ...

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now