Results 1 to 2 of 2
  1. #1
    BudMan is offline Novice
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Location
    Stem, NC USA
    Posts
    23

    Question Different First Page Footer in MS Access 2013

    Using MS Access 2013, part of Office 365, I am trying to construct a report that has a different first page footer than the rest of the document. Googling for answers has produced a few options, but none that seem to work. I have virtually no VBA knowledge. I was hoping that there might be some code that I could place in a label in the footer and have it work.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    in the footer have 2 boxes ,
    txtNorm for your normal footer, INvisible (via properties)
    txt1 for your 1st page footer visible

    once the 1st page goes by , reverse the visibility of each....

    Code:
    Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
    Static i
    
    i = i + 1
    
    If i = 1 Then
        lbl1.Visible = False
        lblNorm.Visible = True
    End If
    End Sub

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

Similar Threads

  1. Replies: 2
    Last Post: 12-21-2013, 02:09 PM
  2. Replies: 2
    Last Post: 10-15-2013, 09:30 AM
  3. Page Footer
    By jamil_kwi in forum Access
    Replies: 1
    Last Post: 05-31-2010, 04:02 AM
  4. Replies: 0
    Last Post: 02-11-2009, 06:43 PM
  5. Page Footer Top
    By RHall in forum Reports
    Replies: 3
    Last Post: 12-15-2005, 09:35 AM

Tags for this Thread

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