display multiple columns in combo box?

F

Fipp

I have a combo box with several columns.
When I drop the box down I can see all the columns. I am trying to get it so
that they are all displayed in the box before I drop it down and after I
select the box that I want.
 
R

Rick Brandt

Fipp said:
I have a combo box with several columns.
When I drop the box down I can see all the columns. I am trying to
get it so that they are all displayed in the box before I drop it
down and after I select the box that I want.
Click to expand...

Can't do it. You can fake it by adding TextBoxes with ControlSource expressions
like...

=ComboBoxName.Column(n)

....where n is the zero based column postion you want to display.
 
W

Wayne-I-M

Hi

The combo will display the 1st column with a width of more than 0 on the
form and will store the bound column.

You can insert text boxes on a form and set the control source for each box
to the combo column

=ComboName.Column(0)
=ComboName.Column(1)
=ComboName.Column(2)
=ComboName.Column(3)
Etc
Etc
 
J

Joan Wild

Modify the following example to suit:

Change the rowsource of your combobox from
SELECT EmployeeID, FirstName, LastName FROM Employees;
to
SELECT LastName & ", " & FirstName AS EmpName, EmployeeID FROM Employees;

Change the bound column to 2.
Change the column widths to 2";0"
 
Top