After receiving the "data type mismatch" error, which I do know how to fix, I can no longer open the report in Design View. Thus, I cannot get at Report Properties to fix the problem. Is this a know bug? Is there any way to recover the report? I lost about an hour's work and seems like it could easily happen again.
closed as off-topic by music2myear, fixer1234, n8te, kenorb, James P Jan 9 at 17:00
- This question does not appear to be about computer software or computer hardware within the scope defined in the help center.
Although I opened and closed both Access and the database several times, the problem with the report persisted. I ran compact and repair with no change.
I spent an hour developing an automatic backup task and, in the process, moved the database to a network location.
The next time I opened the database, I was able to open the report in Design View and see the Report Property Sheet. I have no idea why moving the database worked but I thought I would post it for someone else to try.