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.

Fipp wrote:
> 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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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

--
Wayne
Manchester, England.



"Fipp" wrote:

> 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.

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"

--
Joan Wild
Microsoft Access MVP
"Fipp" <(E-Mail Removed)> wrote in message news:8D4DEDBE-F1C4-469A-879D-(E-Mail Removed)...
>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.

See this article:

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

Ken Snell
<MS ACCESS MVP>

"Fipp" <(E-Mail Removed)> wrote in message
news:8D4DEDBE-F1C4-469A-879D-(E-Mail Removed)...
>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.