I have a combo box that has two columns and when use the drop down both
columns are visible, however, when I select a record then only the detail
from column one shows in the display.

Can anyone help me correct this as I've checked all the properties and it
shows 2 columns with the correct widths etc.

Thanks in anticipation

Sorry, that's the way combo boxes are. When the list isn't descended, only a
single value will show.

If you really need multiple values visible, you can construct an artificial
column that concatenates the values in the query that acts as the recordset
for the combo box. Another option is to have text boxes that get populated
with the "hidden" columns once you select a row in the combo box. To do
this, you'd use the combo box's Column collection in its AfterUpdate event:

Private Sub MyComboBox_AfterUpdate()

Me.Text0 = Me.MyComboBox.Column(1)
Me.Text1 = Me.MyComboBox.Column(3)

End Sub

The code above would take the value from the second column of the selected
row in the combo box and put it in text box Text0, and the value from the
fourth column and put it in text box Text1. (Column starts counting at 0)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Allan Skyner" <(E-Mail Removed)> wrote in message
news:8A8B4B66-AFFE-4D87-A5BE-(E-Mail Removed)...
> I have a combo box that has two columns and when use the drop down both
> columns are visible, however, when I select a record then only the detail
> from column one shows in the display.
>
> Can anyone help me correct this as I've checked all the properties and it
> shows 2 columns with the correct widths etc.
>
> Thanks in anticipation