Report shows all possible values

[notfound]

Hello all,

I generated a report (based on a query) that almost works properly.

One field shows all possible values, rather than the one in the query:

http://img40.imageshack.us/i/accessreport.png/

The right venue is highlighted, but why won't it just show the selected text?

The venue field in the query is looked up from a table with one field.

Thanks for your time,
nf

 

[khawar]

what control you are using in report for showing venue field and what version of access you are using

 

[notfound]

Thanks for the reply khawar, you've pointed me in the right direction,

I'm using Access 2003 SP3 on WinXP.

I used the report wizard which generated a list box control for this field. I changed it to text box and it looks right now.

Any ideas why this field had a list box? It derives from a list box lookup in a table, but other fields do too, and they had the correct text box control.

Anyway, thanks for your reply and your time.

Regards,
nf

 

[khawar]

It adopted the control of data source you have to change it manually if there are combo boxes or list boxes in data source