display multiple columns in combo box?

[Guest]

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.

 

[Rick Brandt]

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.

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.

 

[Guest]

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

 

[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"

 

[Ken Snell \(MVP\)]

See this article:

http://www.mvps.org/access/forms/frm0058.htm