Combo Box

[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

 

[jmonty]

In form design mode open the combo box's Properties dialog
box. On the Data tab you should see Bound Column = 2.
This means the value of the second column will be placed
in your table.
Click the Format Tab and change the Column Count to 2, and
change the Column Widths to 0";1"
This will mean that the the combo box will have 2 columns,
but the first is hidden, and the second column is
displayed.
If you want both columns displayed change the Column
Widths to 1";1"; or whatever widths you choose.
Experiment until you find the one you like.

 

[StCyrM]

Hi

Using the Column Widths property, set the firsr column to 0" and the second to,
say, 1". Adjust the second column to suit.

 

[tom]

Why bother with 2 columns if you are going to hide the first and show the
one that is bound to the table?

Tom.