Combo box as part of a text box

[NeilT123]

I have a text box on a report
=[ManureName] & " " & [OMApplnTypeIndex] & " in " & Format([OMApplicationMonth],"mmm yyyy")

OMApplnTypeIndex is set up in the base table as a combo box and doesn't print as part of the above text box.

Is there any way around this other then having 3 seperate boxes?

 

[Remou]

It is not a good idea to have look-up fields in a table, if that is what you have:

http://www.mvps.org/access/lookupfields.htm

 

[NeilT123]

Thank you for the link, yes I have got look up fields in my tables. I guess I know what I will be doing tomorrow.