Reports: Is current page last page?

[cfrankling]

Hi there,

Is there a way to know if the current page being printed is the last page when generating a report?

I'm trying to hide/show info within Report Footer but want to show it only in the last page.


Thanks in advance
Carlos

[isladogs]

Normally you would use Page # of Pages. Access knows the total number of pages by doing a dummy run first
Not sure why anyone would want to hide that except for on the last page but it would require an extra step.
I'm sure you could do so using VBA but it would likely have a negative effect in terms of performance, especially for reports with many pages.

[ArviLaanemets]

Why don't you use report footer instead of page footers then?

[Micron]

I'm trying to hide/show info within Report Footer but want to show it only in the last page.

By definition, a report footer only shows on the last page. You must be using a page footer as was suggested.

[isladogs]

Good point about using the Report Footer instead of the Page Footer. I've checked and it still shows Page # of [Pages] correctly.
The only issue is that it won't necessarily be at the bottom of the last page - just wherever the report ends.

However, I still don't see why you want to hide that information on other pages