The restriction that it must print at the bottom of the last page wasn't
clear.
Untested suggestion:
I guess you've got some code turning of the page footer visibility except
when it's on the last page - I did say I was curious about that ;-) In that
code, retrieve the height that the subreport has grown to, add the height
you need for your other textboxes and sig line, and change the height of the
Page Footer as well as making it visible.
Another thought:
It may be that you can't get the subreport height initially; perhaps put
that into the OnFormat event (which should trigger if you open the report in
preview mode), and then use it in the OnPrint event to change the height.
You'd need to store the value in a variable which is available within the
report's code module, rather than just in the Sub where you get it.
HTH,
Rob
<ma**********@hotmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
I need this info to print at the very bottom of the last page. The
report footer doesn't always print at the very bottom. This newsgroup
has some good solutions to get around this.
<snip>