We help IT Professionals succeed at work.

Access Show extra column in ComboBox

Murray Brown
Murray Brown asked

I have the a ComboBox whose RowSource is shown in the query below, So far the "Holder" column is the only one shown in the ComboBox. How do I also show the "Licence" information

Watch Question

Under format tab, of the combobox you set the columncount to 3.
If you want to hide the primary key, you can set columnwidth to 0. You can also be more specific and set it to e.g. 0;2;5 if you want greater control over the width of each column.
Distinguished Expert 2017
On the Format tab, you would set:
Column Count to 3
Column widths to 0",1", 1"   ---- or whatever you need for the two visible columns
If you want to see column headers set:
Column Heads to Yes

If you want to make the list wider when it drops down, set:
List Width to whatever makes sense.

Just remember, that when the list is closed, only the first visible column will show.  If you want the other columns to always be visible, the best solution is to modify the RecordSource of the form to join to the lookup table using a LEFT join.  Then you can select whatever extra columns you want from the lookup table.  IMPORTANT - when you do this, make sure that you set the Locked property of these lookup values to Yes to prevent accidental updating. You don't want to update the values in the lookup table from this form.
Murray BrownASP.net/VBA/VSTO Developer


Thanks very much. You both answered so rapidly I didn't realise
Murray BrownASP.net/VBA/VSTO Developer


OK Jim.Thanks