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  

Prevent skip to new page after last page prints



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2010, 11:18 PM posted to microsoft.public.access.reports
Goldar
external usenet poster
 
Posts: 29
Default Prevent skip to new page after last page prints

I have a page header section, a group header section, a group footer section
and a page footer section on my report. The group header I am trying to use
separates groups of records and skips to a new page after each group prints
(the page break is in the group footer). My problem is where to put the page
break so that it doesn't skip to a new page after the last group has printed.

Any help?

Thanks
Ads
  #2  
Old June 5th, 2010, 02:45 AM posted to microsoft.public.access.reports
Allen Browne
external usenet poster
 
Posts: 11,706
Default Prevent skip to new page after last page prints

If you have *no* report footer (or a zero-height one), it should not print a
blank page at the end.

If you need the report footer, drop the Report Header section instead, and
change the report so it has a page break before each new grouping section
(instead of after.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Goldar" wrote in message
...
I have a page header section, a group header section, a group footer
section
and a page footer section on my report. The group header I am trying to
use
separates groups of records and skips to a new page after each group
prints
(the page break is in the group footer). My problem is where to put the
page
break so that it doesn't skip to a new page after the last group has
printed.

Any help?

Thanks


  #3  
Old June 5th, 2010, 04:11 PM posted to microsoft.public.access.reports
Goldar
external usenet poster
 
Posts: 29
Default Prevent skip to new page after last page prints

I have no Report Header and no Report Footer. The page break is positioned in
the Group Footer and I get a blank page (Header text only) after the last
group of data prints. When I move the page break to the Group Header, I get a
blank page (Header text only) at the beginning of the report.

"Allen Browne" wrote:

If you have *no* report footer (or a zero-height one), it should not print a
blank page at the end.

If you need the report footer, drop the Report Header section instead, and
change the report so it has a page break before each new grouping section
(instead of after.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Goldar" wrote in message
...
I have a page header section, a group header section, a group footer
section
and a page footer section on my report. The group header I am trying to
use
separates groups of records and skips to a new page after each group
prints
(the page break is in the group footer). My problem is where to put the
page
break so that it doesn't skip to a new page after the last group has
printed.

Any help?

Thanks


.

  #4  
Old June 6th, 2010, 04:58 AM posted to microsoft.public.access.reports
Allen Browne
external usenet poster
 
Posts: 11,706
Default Prevent skip to new page after last page prints

Remove the page break control.

Instead set the Force New Page property of the section to before (if you do
this in the group header) or After (if you do this in the group footer.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Goldar" wrote in message
...
I have no Report Header and no Report Footer. The page break is positioned
in
the Group Footer and I get a blank page (Header text only) after the last
group of data prints. When I move the page break to the Group Header, I
get a
blank page (Header text only) at the beginning of the report.

"Allen Browne" wrote:

If you have *no* report footer (or a zero-height one), it should not
print a
blank page at the end.

If you need the report footer, drop the Report Header section instead,
and
change the report so it has a page break before each new grouping section
(instead of after.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Goldar" wrote in message
...
I have a page header section, a group header section, a group footer
section
and a page footer section on my report. The group header I am trying to
use
separates groups of records and skips to a new page after each group
prints
(the page break is in the group footer). My problem is where to put the
page
break so that it doesn't skip to a new page after the last group has
printed.

Any help?

Thanks


.

 




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


All times are GMT +1. The time now is 06:13 PM.


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