Combo Box - Bound to column in table

  • Thread starter Thread starter Katherine
  • Start date Start date
K

Katherine

I am trying to do something simple with a combo box. I want it to display as
options all the different entries in one column of a table - the third column
from the left. However, no matter what I do with the settings, it always
shows a list of the entries in the first column in the table (the leftmost
one) - not the third column, even though that one is listed as its "control
source" under properties. Even when I change the number in the "bound
column" box, this does not change. How do I make it work?

Thanks,
Katherine
 
Has to do with what the row source of the combo is, and which column of the
combo you want visible. If the column in the combo (not the form) is the 3rd
column is the one you want to show, then you need to set the combo's column
width properties so it is the only one visible;

0";0";3.5"

Will make the first two columns hidden and the third 3 1/2 inches wide.
See VBA Help on the Column Widths property for details.
 
Thanks!

Klatuu said:
Has to do with what the row source of the combo is, and which column of the
combo you want visible. If the column in the combo (not the form) is the 3rd
column is the one you want to show, then you need to set the combo's column
width properties so it is the only one visible;

0";0";3.5"

Will make the first two columns hidden and the third 3 1/2 inches wide.
See VBA Help on the Column Widths property for details.
Click to expand...
 
Back
Top