Page Number on Report Footer

  • Thread starter Thread starter Bryan Harris
  • Start date Start date
B

Bryan Harris

Is there a way to prevent the report footer from counting as a page in the
page numbering?

I found a technote (q209215) http://support.microsoft.com/?kbid=209215

But it talks about reseting the page numbers for different grouping based
upon the group header.

I have created a traveler for my machine shop and the last page is a job
ready card, but I do not want page numbers to include this printed page.
Any way to do this?

Thanks,
Bryan
 
Bryan said:
Is there a way to prevent the report footer from counting as a page in the
page numbering?

I found a technote (q209215) http://support.microsoft.com/?kbid=209215

But it talks about reseting the page numbers for different grouping based
upon the group header.

I have created a traveler for my machine shop and the last page is a job
ready card, but I do not want page numbers to include this printed page.
Click to expand...


What page numberstuff do you want to avoid?

If it's a Page k Of N kind of thing and you don't want the N
to include the last page, then just use this kind of
expression:

="Page " & Page & " Of " & Pages - 1

If it's just that you don't want to see the page number in
the last page's Page Footer, then make it invisible by using
a little code in the Report Footer section's Format event
procedure:

Me.txtPageNum.Visible = False
 
This worked great. Thank you Marsh!!! I never even thought to make a
formula out of it.

Thanks again,
Bryan
 
Back
Top