Page Breaks

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

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
 
Jim said:
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?
Click to expand...

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

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