Wrong page numbering when viewing a report

[Annie via AccessMonster.com]

Hi all,
I have a report that has some subforms and some sorting in it....it's
working fine....My problem arise when viewing and printing the report, the
pages shows (ex: page 1 of 23) so if you go to the last page it will show (ex:
page 22)....if you go page by page, the pages are fine 23 pages, but if you
jumb to the last page or print it right away it will show 22 pages ....a page
will be disappeared from the report....
Is there any way to code the way we print the report to show the correct
pages.
Thanks for any help you can give.

 

[OfficeDev18 via AccessMonster.com]

Annie,

I betcha you have code in one or more of your report's sections' OnFormat
event. If you can get away with it, and the report will remain user friendly,
try putting any OnFormat code into an OnPrint event for the same section.
(Make a copy of the report before you do this, and work on your copy.)

I have the same problem in one of my reports. Sometimes the last page says
"Page 4 of 3" which makes me look like a jack---, and worse, sometimes the
last page says "Page 5 of 6" which makes the manager wonder where the last
page is. However, there's some code in there that can't be transferred or the
report won't be uniform, so I live with it.

Hope this helps,

Sam

 

[Annie via AccessMonster.com]

Hi sam,
Thanks for your reply....You are right, my report surly has lots of codes,
but unfortunately nothing in "onFormat" in my report but rather they are
"onPrint"...I've been reading a lot in the news group but could't find
anything.....I have no clue what to do and my manager is pushing on that.....
Really no clue what to do....
Thanks a lot Sam, i really appreciate your help.
Annie

Annie,

I betcha you have code in one or more of your report's sections' OnFormat
event. If you can get away with it, and the report will remain user friendly,
try putting any OnFormat code into an OnPrint event for the same section.
(Make a copy of the report before you do this, and work on your copy.)

I have the same problem in one of my reports. Sometimes the last page says
"Page 4 of 3" which makes me look like a jack---, and worse, sometimes the
last page says "Page 5 of 6" which makes the manager wonder where the last
page is. However, there's some code in there that can't be transferred or the
report won't be uniform, so I live with it.

Hope this helps,

Sam

Hi all,
I have a report that has some subforms and some sorting in it....it's

[quoted text clipped - 6 lines]

pages.
Thanks for any help you can give.