tanhus said:
I'm wondering how to write code to format the
group footer so that its always in a new page.
Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
????????
End Sub
Me.GroupFooter1.ForceNewPage = 1, will do what you want. You can put it in
the event you show, but it works just as well if you put it in the Report's
Open event.
Or you can simply set the ForceNewPage property in Design View:
Open the Report in Design View. Click the GroupFooter to select it, and if
the Properties Sheet isn't displayed, right-click and choose Properties.
Under the Format tab, click the down arrow to the right of the Force New
Page property, and choose Before Section.
The Property, at some later date, when you are enhancing or debugging the
Report, may stand out more than the fact that a Form event has code to
accomplish the same thing.
Larry Linson
Microsoft Access MVP
