Hi All, New to this forum so please cut some slack if I do things wrong. I have the same problem as the initial writer. I want a PAGE FOOTER on the last page only of my variable length report. One answer I found was:
Cancel=not[page]=[pages] in the OnFormat event of the footer. This works but leaves a space in all but last page where footer should be!
I've tried making the footer invisible, which then doesn't leave a space but then I can't make it visible for the last page. Things like
Me.pagefootersection.visible=[page]=[pages] don't work.
The previous answer seems a clever solution but surely there should be a more straight forward method.
Thanks