Combo Box

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

I have a combo box with 2 columns. The second column is
the bound column, which goes into my table.

However, the first column shows up in my form. Can I have
the second column show in my form, which is the data that
is going into my table.

Thanks.

DaveB
 
1) You can set the Combo Box's first column ColumnWidths property to 0",
which will then show the second column.
You will not see the first column at all. But then if the second column is
the bound column, why have the unseen first column?

2) Re-work the Combo Box RowSource so that the present first column becomes
the second column and the present second column becomes the first column.
Then change the Bound Column to 1.

Open the Combo RowSource query and just select and drag the 2nd column where
wanted. If the RowSource is a Table, just make it a query, with the fields
in the correct order.
 
Back
Top