Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2006
    Location
    California
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Skip Last Page (2003 - SP2)

    I have a report utilizing the Report Header, Page Header, Detail and Report Footer sections. Depending on the options the User has selected, I would like to not print the Report Footer. The controls in the Report Footer always have data values. I've tried setting Cancel=True in both the Page Header and Report Footer sections, but it still leaves me with a blank page.

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

    Re: Skip Last Page (2003 - SP2)

    You should put the line Cancel = True in the On Format event of the Report Footer section:

    Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
    If ... Then
    Cancel = True
    End If
    End Sub

  3. #3
    Star Lounger
    Join Date
    Apr 2006
    Location
    California
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Skip Last Page (2003 - SP2)

    Thanks,
    Marty

Posting Permissions

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