Need help formatting page footer please

[manning_news]

Using A2K. I've got a page footer that is displayed only on the last
page of the report. There is a subreport, text boxes, and a line for
signature in this footer, in that order. If the subreport has more
than 3 records, the last text box and the signature line get cut off.
How do I format this footer so that nothing gets cut off? Thanks for
any help or advice.

[Rob Parker]

First off, I'm curious as to how you've managed to get a page footer to only
show in the last page of the report.

Other than that, I suggest that you put the subreport, text-boxes and
signature line in the Report Footer, rather than the Page Footer. Set the
Can Grow property of the Report Footer to Yes.

HTH,

Rob
<ma**********@hotmail.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...

Using A2K. I've got a page footer that is displayed only on the last
page of the report. There is a subreport, text boxes, and a line for
signature in this footer, in that order. If the subreport has more
than 3 records, the last text box and the signature line get cut off.
How do I format this footer so that nothing gets cut off? Thanks for
any help or advice.

[manning_news]

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.

Thanks for taking time to reply.


Rob Parker wrote:

First off, I'm curious as to how you've managed to get a page footer to only show in the last page of the report.

Other than that, I suggest that you put the subreport, text-boxes and
signature line in the Report Footer, rather than the Page Footer. Set the Can Grow property of the Report Footer to Yes.

HTH,

Rob
<ma**********@hotmail.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...

Using A2K. I've got a page footer that is displayed only on the last page of the report. There is a subreport, text boxes, and a line for signature in this footer, in that order. If the subreport has more
than 3 records, the last text box and the signature line get cut off. How do I format this footer so that nothing gets cut off? Thanks for any help or advice.

[Rob Parker]

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>