unexpected combo box behavior

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i've got a c.b. on a subform. I've specified that the bound column is 2 of
2. The column widths are 0.25"; 1.5" The correct column is stored in the
control source field, but the first column is left in the combo box when the
drop down list collapses. Is this corrupted behavior or am I missing
something (no doubt obvious)?

thank you
 
The columns are in the same order as they are listed in the Row Source. The
first visible column is the one that will display in the textbox portion of
the combo box after you make your selection. A column is visible if its
width is greater than zero. If you want both columns to display in the drop
down but want the other column to display in the textbox after the
selection, you'll need to reverse them in the combo box's Row Source. You'll
also need to reverse your column widths so that the wider one is the first
one and change your Bound Column to 1.
 
Back
Top