Combo Box

[Guest]

We have a combo box set up with 2 columns but when we click to make a
selection only the first column is redisplayed. How do we get column 2 to be
displayed?

 

[fredg]

We have a combo box set up with 2 columns but when we click to make a
selection only the first column is redisplayed. How do we get column 2 to be
displayed?

Do you mean after you have selected a value?
You can't.
A Combo box will only display the first column whose width is greater
than 0.

If you need to 'see' both columns after selection, add an unbound text
control to your form.
Set it's control source to:
=[ComboName].Column(1)
Where (1) is the number of the column you wish to display (Combo
boxes are zero based so column(1) is the second column.

 

[Douglas J. Steele]

A combo box only shows a single column when it isn't opened. Are you saying
you want column 2 to show instead of column 1? If so, go in and set the
ColumnWidths to 0 (or 0;1, where you can replace 1 with whatever width you
want). Just make sure that the ColumnCount property is 2.