Combo Box question

[AndyShuter]

I have a combo box that displays a text field, but is actually bound to a numerical value in the 2nd colomn

Is there a way in which I can display the text value on a report instead of the numerical value as the report is showing a number, not the text?

Hope I've explained that right!

 

[Mile-O]

Select both number and text fields into the query (in that order) that feeds the combo.
Set the ColumnCount to 2 and set the ColumnWidths to 0

 

[AndyShuter]

Many Thanks!

Many Thanks