Setting ForceNewPage Property

[Anne]

I want to set the ForceNewPage property for a group footer in a report. I
think the code needs to be on the On Print event, but how do I reference the
footer?

Thanks in advance.

 

[Rick Brandt]

I want to set the ForceNewPage property for a group footer in a
report. I think the code needs to be on the On Print event, but how
do I reference the footer?

Thanks in advance.

See the help topic on the Section Property. Your group header/footer
sections can be referenced with...

Me.Section(n)

....where n is the appropriate value. This will vary depending on how many
groups you have. The first group header is 5 with 6 being the first group
footer. Additional group header/footers count up from there with the
headers always being odd and the footers being even.