How to pass to another page when group header change

  • Thread starter Thread starter Marco
  • Start date Start date
M

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
 
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
Click to expand...

Set that GroupHeader's ForceNewPage property to BeforeSection.
It's located on the Format tab of the GroupHeader's property sheet.
 
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
 
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
Click to expand...

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]
 
Back
Top