View Full Version : 2 column combo boxes


rob b
02-26-2001, 03:08 PM
If you have a combo box which shows two fields it usually works when you click into the box, both fields will be shown, but when it hasn't got focus only the first field is shown. Is there a way of showing both fields all the time?

Pat Hartman
02-26-2001, 04:14 PM
Modify the combo box's query.

Select fldA & " " & fldB AS ComboFld, KeyFld
From YourTable
Order by fldA & " " & fldB;

Make sure you change the column count, the bound column, and the column widths properties.