A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Is there a way to force page break for groups?



 
 
Thread Tools Display Modes
  #1  
Old February 15th, 2006, 09:37 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Is there a way to force page break for groups?

Good day!

I have a report that has three groups plus the detail line. I would like to
force a page break whenever information for each group doesn't fit the
remainder of the page.

e.g.
Patient ID: AAAAAA
Case #: BBBBB
Event: CCCCC
Detail line 1
Detail line 2


Patient ID: XXXXX
Case #: YYYYY
Event: ZZZZZ
Detail line 1
Detail line 2
PAGE BREAK PAGE BREAK
Detail line 3
Detail line 4

Is it possible to force the page break before Patient ID: XXXXX? so all
information prints on the next page instead of it being cut?

Thanks in advance!
  #2  
Old February 16th, 2006, 01:12 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Is there a way to force page break for groups?

GOI wrote:
I have a report that has three groups plus the detail line. I would like to
force a page break whenever information for each group doesn't fit the
remainder of the page.

e.g.
Patient ID: AAAAAA
Case #: BBBBB
Event: CCCCC
Detail line 1
Detail line 2


Patient ID: XXXXX
Case #: YYYYY
Event: ZZZZZ
Detail line 1
Detail line 2
PAGE BREAK PAGE BREAK
Detail line 3
Detail line 4

Is it possible to force the page break before Patient ID: XXXXX? so all
information prints on the next page instead of it being cut?



Set the groups KeepTogrther property to Whole Group (in
Sorting and Grouping window).

--
Marsh
MVP [MS Access]
  #3  
Old February 16th, 2006, 01:52 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Is there a way to force page break for groups?

Good day Marshal!

I tried your recommendation and it worked!!! Thank you so much! Really
appreciate your prompt response to my plea. :-)

Again thanks!


Ronnie


Marshall Barton wrote:
I have a report that has three groups plus the detail line. I would like to
force a page break whenever information for each group doesn't fit the

[quoted text clipped - 18 lines]
Is it possible to force the page break before Patient ID: XXXXX? so all
information prints on the next page instead of it being cut?


Set the groups KeepTogrther property to Whole Group (in
Sorting and Grouping window).


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200602/1
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Force page break yusee_ygs Mailmerge 1 January 28th, 2006 06:01 AM
Print page footer only when needed Carl Rapson Setting Up & Running Reports 9 November 14th, 2005 07:57 PM
adding a new page break to an existing page break Edward Letendre General Discussion 1 March 6th, 2005 09:29 AM
Finding/removing an "obascure" manual page break Fred Holmes Tables 2 November 5th, 2004 06:57 PM
odd page section breaks Bill Mitchell Formatting Long Documents 6 June 17th, 2004 02:20 PM


All times are GMT +1. The time now is 08:21 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.