<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=870455518-15052003><FONT face=Arial color=#0000ff
size=2>Rocky</FONT></SPAN></DIV>
<DIV><SPAN class=870455518-15052003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=870455518-15052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=870455518-15052003><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</A><BR><BR></FONT></P></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Rocky Smolin
- Beach Access Software<BR><B>Sent:</B> 15 May 2003 19:47<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] Extra page with
page break in section footer<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Andy:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I tried setting them in code:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT face=Arial size=2>
<DIV><FONT color=#0000ff></FONT><BR>If
Forms!frmRoomInventoryReport!chkPageBreak = False Then<BR>
'PageBreak1.Visible = False<BR> 'PageBreak2.Visible =
False<BR> 'PageBreak3.Visible = False<BR>
Me.Section(6).ForceNewPage = 0<BR>
Me.Section(8).ForceNewPage = 0<BR>
Me.Section(10).ForceNewPage = 0<BR>Else<BR>
Me.Section(6).ForceNewPage = 2<BR>
Me.Section(8).ForceNewPage = 2<BR>
Me.Section(10).ForceNewPage = 2<BR>End If<BR></DIV>
<DIV>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. </DIV>
<DIV> </DIV>
<DIV>Do you see anything I'm doing wrong here or is there perhaps another way
to suppress that last blank page?</DIV>
<DIV> </DIV>
<DIV>MTIA</DIV>
<DIV> </DIV>
<DIV>is</DIV>
<DIV> </DIV>
<DIV>but it leaves the page header by itself.</DIV></FONT>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=andy@minstersystems.co.uk
href="mailto:andy@minstersystems.co.uk">Andy Lacey</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, May 15, 2003 10:54
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Extra page with
page break in section footer</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=020335317-15052003><FONT face=Arial color=#0000ff
size=2>Rocky</FONT></SPAN></DIV>
<DIV><SPAN class=020335317-15052003><FONT face=Arial color=#0000ff
size=2>Rather than do that just set the Force New Page property of the Group
Header to Before Section.</FONT></SPAN></DIV>
<DIV><SPAN class=020335317-15052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=020335317-15052003><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk">http://www.minstersystems.co.uk</A><BR><BR></FONT></P></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> <A
href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</A>
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Rocky
Smolin - Beach Access Software<BR><B>Sent:</B> 15 May 2003
18:44<BR><B>To:</B> <A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><B>Subject:</B>
[AccessD] Extra page with page break in section
footer<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Dear List:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Is there a way to suppress this last
page?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MTIA</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access
Software</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>