Results 1 to 4 of 4
  1. #1
    JosmithTwo is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    19

    I need a Leter Head for each Group Heading that is BEFORE the Page Header

    I have a report consisting of multiple clients. I want my letter head to appear only on the first page of each client Group.



    My problem is the Group Header follows the Page Header so the Page Headings for the Detail line are before my Letter Head in my Client Group Header.

    Suggestions?

    BTW I can get the letterhead to not show by setting the label.visible to FALSE but that causes a large gap at the top of the page.
    Code:
    Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
        If LastClient = ClientName Then
            Label26.ForeColor = vbWhite
            OLEUnbound78.Visible = False
        Else
            Label26.ForeColor = 8388608
            OLEUnbound78.Visible = True
            LastClient = ClientName
        End If
    End Sub

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Try also code setting the label Height property to 0. If that doesn't move everything up, try a textbox as the 'label'.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402
    Another way would be to use can grow/shrink, set the size to say 0.1mm and can grow to yes, it will adjust if data is there and shrink if not.
    Don't use the page header, use the group header and set repeat section to yes for each page

  4. #4
    JosmithTwo is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    19
    I have not been able to get the Height solution to work but luckily the requirements for the report have changed so the problem no longer exists. Thanks for all the ideas.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Should records in the heading on a new page
    By marcvanderpeet12 in forum Forms
    Replies: 2
    Last Post: 06-19-2013, 06:40 AM
  2. Replies: 1
    Last Post: 04-05-2013, 01:58 PM
  3. Replies: 0
    Last Post: 02-25-2013, 04:43 PM
  4. Page Header & Forced Page Break
    By Donnydon in forum Reports
    Replies: 1
    Last Post: 09-08-2011, 08:24 AM
  5. Replies: 3
    Last Post: 08-07-2011, 09:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums