[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 <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 <mailto:andy at minstersystems.co.uk>  
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/a468f1c6/attachment-0001.html>