Page Breaks

[Jim Jones]

I am an Access 'novice' working on a long report which is
divided into sections by grouping on one of my variables.
The group header properties moves the report to a new page
at the end of each section. How can I introduce a second
page break if the section ends on an odd numbered page, so
that all sections start on a right hand page?

Any help would be much appreciated.

Jim Jones
Gaborone
Botswana

 

[Marshall Barton]

I am an Access 'novice' working on a long report which is
divided into sections by grouping on one of my variables.
The group header properties moves the report to a new page
at the end of each section. How can I introduce a second
page break if the section ends on an odd numbered page, so
that all sections start on a right hand page?

Add a PageBreak control name pgSkip at the very top of the
group header section. Then add a little code to the group
header's Format event procedure:

Me.pgSkip.Visible = (Me.Page Mod 2) = 0

 

[fredg]

I am an Access 'novice' working on a long report which is
divided into sections by grouping on one of my variables.
The group header properties moves the report to a new page
at the end of each section. How can I introduce a second
page break if the section ends on an odd numbered page, so
that all sections start on a right hand page?

Any help would be much appreciated.

Jim Jones
Gaborone
Botswana

Jim,
Try adding a page break control at the top of the Group Header.
Code the Group Header Format event:
PageBreakName.Visible = Me.[Page] Mod 2 = 1