S
Spacy Mike
Converted Access 97 to 2007. Everything works except two of the reports.
These two problem reports work fine on the developer pc, but on other
computers, the Page Footer or Report Footer height both expand from about
0.20" to 22".
I can't change the 22" by dragging or changing the Height properties. On the
developer PC (where these two reports are working fine) I selected the whole
report, copied to clipboard, and pasted into a new report. Now the new report
has the same problem as on the other pc (Page Footer and Report Footer height
are stuck at 22").
SOLUTION (that worked):
I then created another new report and copy-and-pasted each section (report
Header, page header, detail, page footer, report footer) one at a time. Then
I made sure that each property was identical betweem the old and new report.
This new report works, so I have to solve the problem by recreating each
report that has this problem. There is some kind of unseen error that is
making this happen. When I select the whole report to copy and paste, the
invisible error is copied too. But when I copied-and-pasted section by
section, the invisible error doesn't get copied.
Does anybody have any idea what could be causing this? There are several
versions of these two reports that are used depending on certain criteria.
Since these reports are essentially the same report, but with a few
modifications, these modified copies have the same problem. I need to get
this resolved before I can upgrade from Office 97 to Office 2007 company wide.
These two problem reports work fine on the developer pc, but on other
computers, the Page Footer or Report Footer height both expand from about
0.20" to 22".
I can't change the 22" by dragging or changing the Height properties. On the
developer PC (where these two reports are working fine) I selected the whole
report, copied to clipboard, and pasted into a new report. Now the new report
has the same problem as on the other pc (Page Footer and Report Footer height
are stuck at 22").
SOLUTION (that worked):
I then created another new report and copy-and-pasted each section (report
Header, page header, detail, page footer, report footer) one at a time. Then
I made sure that each property was identical betweem the old and new report.
This new report works, so I have to solve the problem by recreating each
report that has this problem. There is some kind of unseen error that is
making this happen. When I select the whole report to copy and paste, the
invisible error is copied too. But when I copied-and-pasted section by
section, the invisible error doesn't get copied.
Does anybody have any idea what could be causing this? There are several
versions of these two reports that are used depending on certain criteria.
Since these reports are essentially the same report, but with a few
modifications, these modified copies have the same problem. I need to get
this resolved before I can upgrade from Office 97 to Office 2007 company wide.