How to diaplay a string value from a control with lookup field type?

[George]

Good morning All.

My control data source is of lookup field type. The field being looked up is of string type but my output are numbers. How can I get the report to display the string values rather than numbers?


Thank in advance

[ranman256]

The query behind the lookup, if you need string, in the query, convert it to string: CStr([field])

[ssanfu]

This is one of the reasons that the use of look up FIELDS are discouraged.
I never use them.... They are a real PITA. And from what I can tell, no experienced programmer uses look up FIELDS.
See http://access.mvps.org/access/lookupfields.htm

If you have a form with a combo box that has the control source a look up field, you can try adding an unbound text box with the control source set to the name of the combo box and use the columns property.

Example:
The combo box is named "Combo9" (yeah, I didn't give it a proper name )
The text box control source would be "=[Combo9].[column](0)" (No quotes)

This is assuming that the PK field is the first field in the look up field.