Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Washington, USA
    Thanked 0 Times in 0 Posts

    Displaying a Page Header item on last page (Access 2002)

    I am looking for a way to display a sort line (this is a line to be printed in a specific place- that is used by the sorting machine to stuff envelopes- kinda a page break between muli page documents) in the Page Header in a specific location in the Header, however, on the last page of a multi-page report. Using the Report footer is not acceptable. Since my object is a line - is there any way to reference the line in the report footer to be displayedt in the Page Header.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Displaying a Page Header item on last page (Access 2002)

    You can place the line in the page header, and use the OnFormat event of the page header to show it only on the last page:

    Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
    Me.Line1.Visible = (Me.Page = Me.Pages)
    End Sub

    Replace Line1 by the name of the line, and if necessary, PageHeaderSection by the name of the (you guessed it) page header section.

Posting Permissions

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