Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Force New Page in Report (Access 97/Windows 95)

    Hi,
    I wonder if anybody can help me.
    I have a Group Footer that I want to use a Force New Page after it prints (or previews), but I don't want the Force New Page if the Group Footer is on the last page.
    Pat <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Force New Page in Report (Access 97/Windows 95)

    Well, I worked it out. In the GroupFooter_Format event I placed the following code:

    Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)
    If Page + 1 = Pages Then
    Me.GroupFooter0.ForceNewPage = 0
    End If
    End Sub

    Hope this helps someone else.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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