Combo Probs!

[Rob]

I have a number of combo boxes on my form which have an sql statement to
include three pieces of information. ID as a reference, name and
discontinued yes no so i can see if to choose above another.

When the combo is selected the drop down shows all three pieces of
information in the drop down seperated by faint dividing lines but when the
combo is not selected it only shows one of the pieces of info. How do I get
it to show all three?

I hope I have explained what I mean well enough.

Thanks in advance,

Rob

 

[Sandra Daigle]

Hi Rob,

Your combo is working as intended. The unexpanded list can only show one
value (the value in the first column with width > 0).

A listbox will allow you to show multiple columns - perhaps it will help
you.

The other commonly used to solution is to add a textbox for each additional
piece of information you want to display from the combo. In the
ControlSource of the new textbox put:

=[cboMyCombo].[column](1)

Where 'cboMyCombo' is the name of your combo and where the number '(1)' is
the column number minus 1. The column property is indexed starting with 0 so
the above reference is to the 2nd column of the combo.