Customize ComboBox Display

[Dina01]

I have a combo box that is bound to an SQL statement..

SELECT Effectif_tb.Poste, Effectif_tb.Agent, Effectif_tb.NoAgent FROM Effectif_tb GROUP BY Effectif_tb.Poste, Effectif_tb.Agent, Effectif_tb.NoAgent;

I have it showing 3 fields... but I want it to show only one field... and I don't mean when you click the drop down for the listing... I want it to be shown on the screen when the selection is.

When I click on the drop Down I see the followinf..

Poste Agent NoAgent

But how do I select and then after I want only the NoAgent to Show, because that is what I save to my table.

I looked at the properties and I set my
ColumnNo to 3
ColumsWidth to 3.219cm;3cm;1cm
ColunLink to 3

Can anyone clue me in????

 

[Rich]

0cm;0cm;1cm

 

[Dina01]

Yes, but 0;0;1 only shows the NoAgent, but I want the user to see all the data when he clicks on the drop down and when he let's go of the mouse the selection showed only show NoAgent, Also I need to see the dat in the order of...

Poste Agent NoAgent

 

[David R]

Change the bound column of the combo box.

 

[Dina01]

I did change it but it still has the same effect

 

[David R]

Did you open the widths back up?