Is It possible to anchor thr Report Footer to the bottom of the page?

[RobH]

I have a report (a quotation) which has included in the Report Footer a copy of "terms and Conditions" and a bank deposit slip - With the aim the customer can take the quote to the bank and make a deposit over the bank counter.

The Deposit Slip needs to remain at the bottom of the page so that its easy for the bank to remove the deposit slip component.

As I have subForms in the middle of the report with CanGrow & CanShrik set to yes I am finding that the Report footer moves according to the content on the page.

How can I force the Report Footer to appear at the bottom of the page?

[BradHodge]

I have a report (a quotation) which has included in the Report Footer a copy of "terms and Conditions" and a bank deposit slip - With the aim the customer can take the quote to the bank and make a deposit over the bank counter.

The Deposit Slip needs to remain at the bottom of the page so that its easy for the bank to remove the deposit slip component.

As I have subForms in the middle of the report with CanGrow & CanShrik set to yes I am finding that the Report footer moves according to the content on the page.

How can I force the Report Footer to appear at the bottom of the page?

Rob,

Try putting your quote in the Page Footer instead. This will force it to be at the bottom of the page.

Brad.

[RobH]

Rob,

Try putting your quote in the Page Footer instead. This will force it to be at the bottom of the page.

Brad.

Problem is the Quote can go over two pages. They dont need the deposit slip & terms&Condition s on each page.

[NeoPa]

I don't think there is Rob, I'm afraid.
You could try playing with the Page Format &/or Print events to see if you could amend things on the fly, but I see no option to anchor the Report Footer section (except to the top of the page).
I would look at an empty (&/or hidden) Label control (or TextBox) and see if I couldn't change its status or contents at Format / Print time to display what you need.

[barry07]

One thing you can do is put the deposit slip in the page footer and hide it if page number is greater than one. The only snag is the subsequent pages will have a blank area of the same size in the footer. (I tried varying the PageFooter height dynamically, but it doesn't seem to work).

This is the code assuming the Deposit Slip is a single label - if this is not the case you can enclose it in a group and make the group invisible in the same way

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If Page > 1 Then
    Label1.Visible = False
Else
    Label1.Visible = True
End If
End Sub