Combo Box Column with No Data

  • Thread starter Thread starter Darrell
  • Start date Start date
D

Darrell

I have a table, the first column of which I seem to be unable to get to
appear in a combo box column. Instead I get a column which appears completely
blank, though the Row Source indisputably contains the desired values. Any
ideas?

Thanks, as always, for any and all suggestions.
 
Have you checked the column count property of the combo? Try 3 and see if any
more show.
 
I have a table, the first column of which I seem to be unable to get to
appear in a combo box column. Instead I get a column which appears completely
blank, though the Row Source indisputably contains the desired values. Any
ideas?

Thanks, as always, for any and all suggestions.
Click to expand...

Check the ColumnCount (it should match the number of fields in the row source
query, and that should match the number of fields you want included) and the
BoundColumn (if you want the first column stored, use 1); also check the
ColumnWidths property - it will be a string like

0";1";0.5"

meaning that the first column is zero width (concealed from view), the second
one inch, and the third half an inch. Be sure the column you want to see is
nonzero.

When the combo is dropped down you'll see all the nonzero width fields (if the
combo's wide enough of course); when not dropped, you'll see the first nonzero
width column.
 
Back
Top