Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I want report footer to print with last group detail 1

Status
Not open for further replies.

LonnieJohnson

Programmer
Apr 16, 2001
2,628
US
I have a report that has a group section. I have the "force new page" property set to "after section".

There is also footer section with totals and it shows on a page by itself since the force new page is turned on.

How can I get the footer page to print with the last page of the group section?

ProDev, Builders of Affordable Software Applications
Visit me at ==>
May God bless you beyond your imagination!!!
 
I expect you can replace the "force new page" property setting with a pagebreak control at the bottom of the section. Then add [Page} of [Pages] to the report and place code in the section with the pagebreak like:
Code:
   Me.PageBreakCtrl.Visible = [Page]<[Pages]

Duane
Hook'D on Access
MS Access MVP
 
Thank you Sir. I will try this ASAP after I put out a major fire I created.

ProDev, Builders of Affordable Software Applications
Visit me at ==>
May God bless you beyond your imagination!!!
 
Thanks. This worked perfect.

ProDev, Builders of Affordable Software Applications
Visit me at ==>
May God bless you beyond your imagination!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top