Problem in ComboBox

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.

On Tue, 8 Jun 2004 19:09:01 -0700, Ganesh
wrote:

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

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Here are the information that you need:
SQL View of the query: SELECT [aor_no] & " " & [aor_desc] AS aor_display, tbl_619_ioc_cd.ioc_parent_cd, tbl_619_ioc_cd.internal_org_cd, tbl_619_ioc_cd.aor_no, tbl_619_ioc_cd.aor_desc, tbl_619_ioc_cd.aor_manager_nm
FROM tbl_619_ioc_cd
ORDER BY tbl_619_ioc_cd.aor_no;
Control Source: internal_org_cd
Bound Column: 3
Column Count: 6
Column Widths: 2.5";0";0";0";0";0"
Please help.

"John Vinson" wrote:

On Tue, 8 Jun 2004 19:09:01 -0700, Ganesh
wrote:

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

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public