Text Box showing Primary Key ID instead of data

[patrickmcdiver]

I have a report that I am generating from a table which thru a filter show tasks that are past due. The text boxes on the report are:

Tasks.Project, Tasks.Title, Tasks.Assigned To, and Tasks.Date Due

The report does what I want it to do except that it shows a number (Tasks.ID) instead of the Project. I can't figure out why this is happening or how to stop it. Please help!

 

[SOS]

You probably have Lookups defined at table level, don't you? If so, remove them.

 

[Khalid_Afridi]

Its true SOS,
And also if your bound column and count column number of columns, are not properly defined in combo box then it will give you strange results in the list box or reports fields/columns.

 

[patrickmcdiver]

Thanks guys