Printing in a specific place on a report

[Moira Triance]

I need to produce an invoice on preprinted stationary where the totals are at the bottom of the page. This is fine if the invoice is only one page, as I can make the detail section a fixed size, but what if the invoice goes to more than one page? Does anyone know how I can put the totals at a specific location on the last page? Any help gratefully accepted.

 

[cpod]

Well, the page footer always prints at the bottom of the page, so you can put them in the page footer and then hide the footer on all but the last page.

You cannot actually sum in a page footer. You have to add a report footer with a textbox for the sum, say txtSum. Then in the page footer have a text box (call it txtSumFooter) with:

=txtSum

Also in the report footer add a textbox with:
=[pages]

Set the visible property of the report footer to "No".

To hide the page footer except on the last page put this code in the Page footer format event:

If Me.Page <> Me.Pages Then
Me!txtSumFooter.Visible = False
Else
Me!txtSumFooter= True
End If