Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Report Page Breaks with Group Headers


Message #1 by "Gregory Serrano" <SerranoG@m...> on Wed, 20 Feb 2002 20:11:15
I have a report in Access XP.  I have the ForceNewPage property for the 

group header set to "Before Section".  The problem is that it's putting a 

page break before the first group so that the first group starts on Page 

2.  Page 1 is blank except for the Report Header and Page Footer.



How can I get the ForceNewPage property to ignore itself for Page 1 of the 

report?



I've tried this on the group header's "On Format" property, but it doesn't 

work:



   If Me.Page = 1 Then

      Me.GroupHeader0.ForceNewPage = 0

   Else

      Me.GroupHeader0.ForceNewPage = 1

   End If



Greg

Message #2 by Lonnie Johnson <prodevmg@y...> on Wed, 20 Feb 2002 12:12:04 -0800 (PST)
--0-607485756-1014235924=:89499

Content-Type: text/plain; charset=us-ascii





 Create a page foot for this same group. Then put the ForceNewPage After Section on the Footer.

  Gregory Serrano <SerranoG@m...> wrote: I have a report in Access XP. I have the ForceNewPage property for the 

group header set to "Before Section". The problem is that it's putting a 

page break before the first group so that the first group starts on Page 

2. Page 1 is blank except for the Report Header and Page Footer.



How can I get the ForceNewPage property to ignore itself for Page 1 of the 

report?



I've tried this on the group header's "On Format" property, but it doesn't 

work:



If Me.Page = 1 Then

Me.GroupHeader0.ForceNewPage = 0

Else

Me.GroupHeader0.ForceNewPage = 1

End If



Greg








Lonnie Johnson ljprodev@y... 

ProDev, Builders of MS Access Databases

Let ProDev build your next MS Access database application. 

http://www.galaxymall.com/software/PRODEV 



Get paid cash every time you receive email!

Sign up FREE at: http://www.MintMail.com/?m=975303





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

Do You Yahoo!?

Yahoo! Sports - Coverage of the 2002 Olympic Games


Message #3 by "Gregory Serrano" <SerranoG@m...> on Wed, 20 Feb 2002 21:40:02
Lonnie,



<< Create a page foot for this same group. Then put the ForceNewPage After 

Section on the Footer. >>



Thanks.  This did the trick.



Greg


  Return to Index