Display 2 Columns in Combo Box?

[10 Gauge]

Curious if there is a way to get multiple columns to display in a combo box in the selected state. The columns work just fine when selecting something, but after the item has been chosen, it only displays the first column.

TIA!

[pbaldy]

Technically no, though you can concatenate in the row source:

SELECT FirstName & " " & LastName AS FULLName...

and display the concatenated column. The other way is to have a separate textbox:

=ComboName.Column(x)

where x is the number of the desired column to display.

[10 Gauge]

Thanks Pbaldy, option 2 will work very well for me.

[pbaldy]

Happy to help; I typically use option 2 myself.