Data in query table missing from report

[nick.muir2]

Hi Everyone, I have created query and all my values come into the table from the query fine.



When i then go and generate the report all of the boxes are there for the data but there is no data in them. For owner and Job Id all info is there but job name, Department and a few others there is no data in the boxes.

Help is greatly appreciated.

Nick

[JoeM]

How did you create the report?
Did you start with bound record source?
Are all your text boxes bound to fields in the record source and do the names match?
What happens if you look at the list of available fields and try dragging those fields to the report again?

My only other thought is to check for VBA code that might be hiding/affecting the display of those fields.

[nick.muir2]

Thanks for responding Joe. It turned out that some had come through as list boxes once I edited that it all worked fine