How to set the combo box to display the 3rd column after selected by user

[thepooh]

I've created a combo box in Access where I've set the Column Count = 3 and the Column Widths to 0";0.5";1.5". The first field is hidden as it is the ID. The 2 other fields are visible to the user. When the user select the record, the combo box will display the value in the 2nd column as the selected record. What I would like to do is display the 3rd column and not the 2nd column. Is there any way that I can do this? I can't seem to find any properties to set it. Thanks.

 

[IMO]

Set the second column width to 0" or swap the two fields around in the Row Source

IMO

 

[thepooh]

I would like the user to see both fields, but after selected, the field that is displayed should be the 3rd one. It will be better if both columns are displayed but I think only one is allowed.

 

[IMO]

Swap the fields around in the Row Source

IMO