A Report that has been used for many months has several labels on it that have suddenly vanished when the report is opened. You can see the labels in the form design mode but cant see them when the report is open (so I know they are there).
Any ideas on why this may be happening.
I have compacted the db, copied the report to a new report, checked the label properties such as visible, and tried other variations but the labels are still gone. The labels appear in the Report Header, Footer, and detail sections.
Interestingly enough, I have a backup of the report in the same database that where the labels are still visible.
What could have caused this. I am baffled?