Combo Box Display Multiple Column Info After Selection Made
 

I am using a form which has a combo box with drop down list. Well, I
have three columns in my list just as I want and I am having no
trouble getting the correct info by using the bound column
properties.

However once I make a selection from the dropped down list the combo
box only displays the item from the first columns. Is there a way to
show all three of my items from all three of my columns.

For example, let's say my drop down list shows the following list of
choices each of which come from three columns:


2x4 Spruce fir Borate Treated 24SFBT
2x6 Spruce fir Borate Treated 26SFBT

So, lets say I click select the first item row (2x4 Spruce fir
Borate Treated 24SFBT)

When the combo box updates, the only info it shows to the user is: 2x4
Spruce fir

Is there a way to let it show the enti 2x4 Spruce fir Borate
Treated 24SFBT ????

Coby.