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
geppo - 31 Dec 2007 17:39 GMT
> Hi,
>
[quoted text clipped - 5 lines]
> Thanks
> Chi
He is not able'

Signature
Ciao
Geppo
fredg - 31 Dec 2007 17:55 GMT
> Hi,
>
[quoted text clipped - 5 lines]
> 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.

Signature
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Beetle - 31 Dec 2007 17:56 GMT
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

Signature
_________
Sean Bailey
> Hi,
>
[quoted text clipped - 5 lines]
> Thanks
> Chi
John W. Vinson - 31 Dec 2007 19:28 GMT
>Hi,
>
[quoted text clipped - 5 lines]
>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]
Linq Adams - 31 Dec 2007 20:37 GMT
What exactly are you using this combobox for?

Signature
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Chris - 31 Dec 2007 23:24 GMT
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.
Chris - 31 Dec 2007 23:27 GMT
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.