[AccessD] Extra page with page break in section footer

MessageAndy:

There's a 'page break' check box on the calling form.  So I set the page breaks (up to three because there can be three sort fields selected) visible or not depending on the check box.  

I tried setting them in code:


If Forms!frmRoomInventoryReport!chkPageBreak = False Then
    'PageBreak1.Visible = False
    'PageBreak2.Visible = False
    'PageBreak3.Visible = False
    Me.Section(6).ForceNewPage = 0
    Me.Section(8).ForceNewPage = 0
    Me.Section(10).ForceNewPage = 0
Else
    Me.Section(6).ForceNewPage = 2
    Me.Section(8).ForceNewPage = 2
    Me.Section(10).ForceNewPage = 2
End If

but it's not coming out right.  The sections are breaking in funny places.  I tried commenting out 6,8, and 10 in various combinations but nothing seems to work just right.  

Do you see anything I'm doing wrong here or is there perhaps another way to suppress that last blank page?

MTIA

is

but it leaves the page header by itself.
  ----- Original Message ----- 
  From: Andy Lacey 
  To: accessd at databaseadvisors.com 
  Sent: Thursday, May 15, 2003 10:54 AM
  Subject: RE: [AccessD] Extra page with page break in section footer


  Rocky
  Rather than do that just set the Force New Page property of the Group Header to Before Section.

  Andy Lacey
  http://www.minstersystems.co.uk



    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software
    Sent: 15 May 2003 18:44
    To: AccessD at databaseadvisors.com
    Subject: [AccessD] Extra page with page break in section footer


    Dear List:

    I have a couple of reports which the client wants to page break on the major sort field.  SO I put a page break control in the section  the section footer which works just fine except I'm getting an extra blank page at the end of the report.

    Is there a way to suppress this last page?

    MTIA

    Rocky Smolin
    Beach Access Software



------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030515/1bfc8f99/attachment-0001.html>