Page Breaks for Group Headers on Odd Pages

[Guest]

I am creating a report for a course catalog and I want each group header to
be on an odd page. I am grouping by category of class, i.e business skills,
pc skills, etc. No matter what page the last page of the group falls on, I
want the next group to always start on an odd page. If you are familiar
with word, i want it to act like a section break / odd page.

Any ideas?

 

[Marshall Barton]

I am creating a report for a course catalog and I want each group header to
be on an odd page. I am grouping by category of class, i.e business skills,
pc skills, etc. No matter what page the last page of the group falls on, I
want the next group to always start on an odd page. If you are familiar
with word, i want it to act like a section break / odd page.

Add a Page Break control named pgSkip at bottom of the
group footer section velow all the other controls. Then add
a line of code to the footer section's Format event:

Me.pgSkip.Visjble = (Me.Page Mod 2) = 1

Double check to make sure the group header section's
ForceNewPage property is set to Before Section.