How to Multi-column combo box display

[ErikZ]

Ok, I have a working combo box, it shows the Item ID, the name and the customer. After the user selects an item, the combo box only shows the Item ID. How do I get it to show everything?

 

[hblabonte]

Erik,

Look at the properties for the combo box. Make sure the column count says 3. Then look at the column widths. That's where you specify which column(s) you want to be displayed.
1";1";0" means, display columns 1 & 2, but not 3. You can adjust the width of the particular column that way too.

-Heather

 

[ErikZ]

Right, the part where the user selects an item works fine. when the box drops down it shows all three columns. AFTER the user selects an item and the box colapses to one row, only the ItemID is displayed.

How do I get it to show all three rows?

 

[hblabonte]

I believe that the column that gets displayed after you select it, is the bound column only. What I've done if I want to show more than one column, is to create a new "field" with SQL of what I want to show and use that as the bound column. It works great for me. Make sense?

SELECT Field1, Field2,
Field1 + ' | ' + Field2 AS CmbField
FROM dbo.Tblblah

With this example, I'd use column 3 as the bound column.

-Heather