Problem in ComboBox

[Guest]

I have a combobox in one of my access form. I am using a
query to populate the combobox. When i am setting the
BoundColumn property to a nonzero value, i am getting a
truncated list in the combobox. But when i am using
boundcolumn property as 0 or blank, i am getting full list
in the combobox. Any pointers to this problem and it's
solution will be highly appreciated.
As suggested by some programmer i have matched the column count of the query populating the combobox, column count and Column Widths (width of all the columns separated by semicolon) properties. of the combox. But this didn't help. Please help.

 

[John Vinson]

I have a combobox in one of my access form. I am using a
query to populate the combobox. When i am setting the
BoundColumn property to a nonzero value, i am getting a
truncated list in the combobox. But when i am using
boundcolumn property as 0 or blank, i am getting full list
in the combobox. Any pointers to this problem and it's
solution will be highly appreciated.
As suggested by some programmer i have matched the column count of the query populating the combobox, column count and Column Widths (width of all the columns separated by semicolon) properties. of the combox. But this didn't help. Please help.

I'm confused. Please post the following properties of the combo:

- the SQL view of the Rowsource query
- the Control Source (which field in the form's recordsource you want
to update or to have the combo reflect)
- the Bound Column
- the ColumnWidth property