Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2007
    Posts
    8

    Unanswered: MS Access Suppress Page Header Help!!

    I am trying to suppress the page header on the first page of a grouping based upon page zero = 0 but its not working.

    Here is the code I'm using in the events for the page header section:

    If Me.[Page No 2] = 0 Then
    Me.GroupHeader2.Visible = False

    Group Header 2 is where I need to suppress the page header, the page number (in the page header section) is written as follows:
    ="Page " & [Page]-1

    I do not have any detail sections, only group header sections.

    Can anyone assist?

  2. #2
    Join Date
    Sep 2006
    Posts
    265
    On the report properties there is:

    Page Header:

    Change is to: Not with Report Header

    Simon

  3. #3
    Join Date
    Sep 2007
    Posts
    8

    MS Access Suppress Page Header Help!!

    Thanks Simon, but I need to suppress the page header for every grouping not just the first page. I have approximately 35 groupings I need to suppress the page header at each group change. Do you have any other suggestions?

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Are there Group Headings?
    If so, why not just use them.
    Can you use "force new page" for each group?
    George
    Home | Blog

  5. #5
    Join Date
    Sep 2007
    Posts
    8
    There are group headings and I am forcing a new page for each group but the page header still displays/prints with the first page of the new group, which is what I need to suppress. The first page is a distribution page with a return address and the page header is interfering.

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Hmm..
    Make the report header a page big?
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •