Combo box and data

[Chi]

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]

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'

 

[fredg]

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.

 

[Beetle]

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

 

[John W. Vinson]

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]

 

[Linq Adams via AccessMonster.com]

What exactly are you using this combobox for?

 

[Chris]

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]

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.