Suppress group header when forcing extra page in report

Posted on 2011-10-28
Last Modified: 2013-11-28
Working on a long report which prints duplex to save paper.  However the client wants each group to begin on an odd page, so we can insert dividers into the report.  

I've added code which prints a pagebreak in the group footer if the footer is on an odd numbered page.  That part works great.  But the even numbered page that prints when this occurs contains the group header, which is set to repeat.

How do I suppress the group header from printing when this extra pagebreak is being printed?
I've tried setting the group header visible property to False, and changing the RepeatSection property but neither of these is working, at least not in print preview mode.
Question by:Dale Fye (Access MVP)
    LVL 77

    Expert Comment

    Haven't tried this but I would guess you would switch 'repeat section' on and off as required.

    In the group header print event procedure.

    Me.Section.RepeatSection = True

    and in the group footer set it to false.
    LVL 74

    Accepted Solution

    LVL 30

    Expert Comment

    If issue persists, attach a simple report reproducing the issue with suitable test data.
    LVL 47

    Author Comment

    by:Dale Fye (Access MVP)

    Have not forgotten you, just got retasked and have not had a chance to play with the recommendations.  Will hopefully get back to this tomorrow.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    LVL 47

    Author Closing Comment

    by:Dale Fye (Access MVP)

    This was precisely what I was looking form.  Thanks.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now