[AccessD] Extra page with page break in section footer

MessageAndy:

She's a-still no work.  I tried After Section because these are the footers. But, of course, I've got three footers so that doesn't work out too well.  Before section would be better for the header sections, no?, but then it leaves the report header on a separate page.   :(

Not sure how to get around this one.

Yet.

Rocky

  ----- Original Message ----- 
  From: Andy Lacey 
  To: accessd at databaseadvisors.com 
  Sent: Thursday, May 15, 2003 11:57 AM
  Subject: RE: [AccessD] Extra page with page break in section footer


  Rocky
  I'd set it to 1 (ie Before Section) if I were you. That's what I always use and never have any bother. I take it you've removed the manual page breaks cos they'd be messing you up otherwise.

  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 19:47
    To: accessd at databaseadvisors.com
    Subject: Re: [AccessD] Extra page with page break in section footer


    Andy:

    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



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


  _______________________________________________
  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/cff9c06a/attachment-0001.html>