Combo Box - Cannot display choice

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

Guest

What am I doing wrong? I cant seem to display the
selected column in my combo box. The combo box displays
the left most visible column only even though all four
columns are visible.
Column Count = 4
Column Width = Blank (or 2.0;2.0;2.0;2.0)
Row Source Type = Table/Query
Row Source = SELECT [id], [firstname], [surname], [phone]
FROM customer ORDER BY [firstname];
Bound Column = (It does not matter what I choose the
first visible column is displayed- values 1,2,3,4)


Thanks Clive
 
What am I doing wrong? I cant seem to display the
selected column in my combo box. The combo box displays
the left most visible column only even though all four
columns are visible.
Column Count = 4
Column Width = Blank (or 2.0;2.0;2.0;2.0)
Row Source Type = Table/Query
Row Source = SELECT [id], [firstname], [surname], [phone]
FROM customer ORDER BY [firstname];
Bound Column = (It does not matter what I choose the
first visible column is displayed- values 1,2,3,4)

Thanks Clive
Click to expand...

A combo box only displays all of the columns when the combo arrow has
been clicked (during dropdown). Otherwise, only the first visible
column is shown.

With the column width properties you have indicated above
(2.0;2.0;2.0;2.0) only the ID column will display after you have made
a selection.

To display the FirstName column, change the column widths to:
0";2";2";2"

If you wish to display the Surname after the selection, while still
being able to view the FirstName during dropdown, then change the
Combo rowsource to:
SELECT [id], [Surname], [Firstname], [phone]
FROM customer ORDER BY [Lastname];

and change the Column Widths to:
0";2";2";2"

The bound column value will be saved to your table, regardless of
which column is actually being viewed.
 
When the dropdown list is not visible any more, the combo box will display
only the left-most, visible column's value. The number entered for the Bound
Column has no effect on what is displayed; that sets the column that
establishes the value of the combo box. It will not show multiple values. To
show the other columns' values, use textboxes on the form to hold the values
and then use the technique shown on The ACCESS Web to show the values:
http://www.mvps.org/access/forms/frm0058.htm
 
Back
Top