List box in report

[RachelMillington]

Am new to reports and need your help.

I created a report from a query. On the the fields was a list box, and in
the report it is showing the whole list with the selected option from the
list box highlighted.

I just want it to show the selceted option, not the whole list, but dont
know how to do this.

Please help.

 

[Rick B]

Then don't make it a list box. That control is not really well suited for a
report. Make it a textbox.

 

[tina]

sounds like that field is a Lookup field in the table. suggest you get rid
of the Lookup at the table level, see
http://www.mvps.org/access/lookupfields.htm for reasons why.

hth