Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Page Footer alone (Access2003)

    Pleased, help me to not to print page header with page footer.
    I want pafe footer to be printed after the Report data but IF on anew page - than Page Header shouldn't be there. Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Page Footer alone (Access2003)

    I'm not entirely sure what you mean, but see if the following does what you want:

    1) Make sure that there is a text box in the page header or footer that refers to [Pages] (the number of pages in the report), for example with a control source of

    =[Pages]

    or

    ="Page " & [Page] " of " & [Pages]

    2) Write code for the On Format event of the page header, e.g.

    Private Sub PageHeader_Format(Cancel As Integer, FormatCount As Integer)
    Cancel = (Me.Page = Me.Pages)
    End Sub

    where PageHeader is the name of the page header section.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Footer alone (Access2003)

    I am not sure if this will do what I want.
    I have a page footer with "Page " & [Page] " of " & [Pages]and it has different Label with text for the page footer.

    Now I need a Report footer to display text after the whole Report.
    It does work but Page Header is coming up as well,
    It use to be where you can select Except Report Footer for the Page Header to be displayed on every page except when this page displaying Report FOOTER, I can't find this property...
    Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Page Footer alone (Access2003)

    Open the report in design view.
    Activate the Format tab of the Properties window.
    Make sure that the Caption of the Properties window says Report.
    Set the Page Header property to "Not with report footer".

  5. #5
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Footer alone (Access2003)

    Thanks so much.

    How can I say 'do not print label in Page Footer if it is a last page'? Because NOW there is a Report Footer's label there. So I want to take page footer's label out just from last page.

    THANKS

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Page Footer alone (Access2003)

    Is the label the only control in the page footer, or does the page footer contain other controls that should remain visible?

  7. #7
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Footer alone (Access2003)

    The line and Page of Pages is there as well. They should remain visible OR if it is esier by much - don't.
    Thanks

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Page Footer alone (Access2003)

    You can use code in the On Format event of the page footer:

    Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer)
    Me.LabelName.Visible = Not (Me.Page = Me.Pages)
    End Sub

    Where PageFooter is the name of the page footer section and LabelName is the name of the label that you want to hide on the last page.

  9. #9
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Footer alone (Access2003)

    I appreciate your help...as those other 1000 times...:-))

Posting Permissions

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