How to see more columns in the diplay of a combobox

Question

in an acces form I have a combobox with 5 columns of which one is the bound colomn. In the pulldown menu I see these 5 columns. if I click I only see one column item in the display. How can I see more columns? Maybe the textcolumn property should be set. But I do not know where to find it.

Answer 1

Hi,

You can't. A combobox can only show 1 column in its textbox part. Two workarounds:

1. You could use a concateneted column (Field1 & ", " & Field2 ...) as the first visible column. You can assign it a column width of 0.01 to only see it in the textbox part, not in the list.
2. You could show the other columns in a separate textbox next to the combobox using a textbox control source like: =YourCombobox.Column(1) & ", " & YourCombobox.Column(2) ...

Servus
Karl

---

Access Forever News DevCon
Access-Entwickler-Konferenz AEK

Answer 2

For an example of how to display data from multiple columns in a combo box's list, by showing the values in additional unbound controls in the form you might like to take a look at DatabaseBasics.zip in my public databases folder at:

 

https://1drv.ms/f/c/44cc60d7fea42912/EhIppP7XYMwggESpAAAAAAAB3aLXYo7DdARg01KnQIyoLg?e=fASl3m

 

In this little demo file, the third form in the section on 'entering data via a form/subforms' is a simple Orders form in which the customer is selected in a combo box whose list includes the customer's address data.  These data are then shown in four unbound text boxes below the combo box.

 

In the section on 'retrieving data from the database' in the same demo you'll find an example of a 'Select Contacts' combo box which shows data concatenated into a single column in the control's RowSource query.

Answer 3

Karl gave me a very good suggestion. So my problem is solved

Answer 4

Thanks Ken, I have solved the problem with the suggestion nr 1 from Karl