Combo box and data

Hi,

My combo box has three columns. As normal, it shows only one column after
choosing the record from the list.

Please show me how to make the combo box shows all three columns.

Thanks
Chi

Ciao Chi wrote:
Hi,

My combo box has three columns. As normal, it shows only one column
after choosing the record from the list.

Please show me how to make the combo box shows all three columns.

Thanks
Chi


He is not able'


--
Ciao
Geppo

On Mon, 31 Dec 2007 09:29:00 -0800, Chi wrote:

Hi,

My combo box has three columns. As normal, it shows only one column after
choosing the record from the list.

Please show me how to make the combo box shows all three columns.

Thanks
Chi

You can't show more than one column after selection.
What you can do is add an additional text control for each of the
other columns you wish to show.
Set it's control source to:
=[ComboName].Column(1)

Because Combo Boxes are Zero based, the above will show the second
column. Change (1) to whatever the actual column number is.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Open the properties sheet for your combo box, go to the format tab, and set
the column widths to something like;

1";1";1"


HTH
--
_________

Sean Bailey


"Chi" wrote:

Hi,

My combo box has three columns. As normal, it shows only one column after
choosing the record from the list.

Please show me how to make the combo box shows all three columns.

Thanks
Chi

On Mon, 31 Dec 2007 09:29:00 -0800, Chi wrote:

Hi,

My combo box has three columns. As normal, it shows only one column after
choosing the record from the list.

Please show me how to make the combo box shows all three columns.

Thanks
Chi

A couple of possibilities:

1. Base the Combo on a Query with a calculated field concatenating the three
fields.
2. Put two additional textboxes on the form next to the combo, with control
sources like

=comboboxname.Column(n)

where n is the *zero based* index of the field that you want to see.

John W. Vinson [MVP]

What exactly are you using this combobox for?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

As descriped in the other posts, the combo-box will only "Display" the
selected item once selected. That is the nature of the object.

You can change the properties of the combo box (on the Format tab) by
putting the total number of columns in the "Column Count" field and then the
desired column widths in the "Column Widths" field (something like 1";1";1").
This will allow you to "See" all the fields during the selection process.

Once selected, only the data for the actual selection will show. However,
if you create unbound text fields and set the control sourse to
"=[ComboName].Column(x)" (where x equals the column you what to display
[remember they start with 0 and increament upwards]). Set these fields to
locked and uneditable to reduce confusion for the user.

Once selected, only the data for the actual selection will show. However, if
you create unbound text fields and set the control sourse to
"=[ComboName].Column(x)" (where x equals the column you what to display
[remember they start with 0 and increament upwards]) you will be able to see
the other data.

Also, set these fields to locked and uneditable to reduce confusion for the
user.