Access 2007 Report Footer

[tuglet]

I'm designing a report in Access 2007. I need the controls in the report footer to appear in the same position every time the report is printed - they're invoice totals which need to appear in a preprinted box on the invoice stationery. Being totals, I only want them to appear on the last page of the report. I could move the controls to the page footer section but then they appear on every page, which I don't really want. Any suggestions would be greatly appreciated.

[5pen]

You could try placing the totals in the report footer and set the 'Visible' property of the text box to 'No', then place an unbound Text Box control in the page footer with the control source of =IIf([Page]=[Pages],[ReportFooterControlName])

Basically that says "If the page number is equal to the total number of pages, show the report footer control in the page footer"

Hope that makees sense.

Tested very quickly, but it worked for me.

[tuglet]

5pen said:

You could try placing the totals in the report footer and set the 'Visible' property of the text box to 'No', then place an unbound Text Box control in the page footer with the control source of =IIf([Page]=[Pages],[ReportFooterControlName])

Basically that says "If the page number is equal to the total number of pages, show the report footer control in the page footer"

Hope that makees sense.

Tested very quickly, but it worked for me.

That makes perfect sense. I'll give it a try on Monday morning. Thanks a lot.

[5pen]

Slight error in my reply, I forgot the ELSE "" part of the IF statement, ie there should be a ,"" after the text box name and before the closing bracket.