How to pass to another page when group header change

[Marco]

Hi. I have a report and in that report I have a group header.

Is it possible to force the the report to start in a new page whenever the
group header change?


Regards,
Marco

 

[fredg]

Hi. I have a report and in that report I have a group header.

Is it possible to force the the report to start in a new page whenever the
group header change?

Regards,
Marco

Set that GroupHeader's ForceNewPage property to BeforeSection.
It's located on the Format tab of the GroupHeader's property sheet.

 

[Marco]

thanks.

By the way, way the Group Footer of the same group don't repeats on the next
page?


How can I for the page number to change/reset when the group header changes?

Thanks,
Marco

 

[fredg]

thanks.

By the way, way the Group Footer of the same group don't repeats on the next
page?

How can I for the page number to change/reset when the group header changes?

Thanks,
Marco

1) Set the GroupHeader's RepeatSection property to Yes.
It's on the Format tab.

2) See:
"Printing First and Last Page Numbers for Report Groups "
http://www.mvps.org/access/reports/rpt0013.htm

Things to make sure of:

1) Add an unbound control to the Page Footer.
Name this control "ctlGrpPages"

2) Paste the code into the Page Footer Format event.

3) In the code, change Me!Salesman to
Me![Name of the control used to group by]