From: Goldar on
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
From: Allen Browne on
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" <Goldar(a)discussions.microsoft.com> wrote in message
news:8340DE38-2350-4158-8EF1-E308D06B2223(a)microsoft.com...
> 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

From: Goldar on
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" <Goldar(a)discussions.microsoft.com> wrote in message
> news:8340DE38-2350-4158-8EF1-E308D06B2223(a)microsoft.com...
> > 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
>
> .
>
From: Allen Browne on
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" <Goldar(a)discussions.microsoft.com> wrote in message
news:7A2361A2-3C71-48EA-AD75-3DB3BFCB2041(a)microsoft.com...
> 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" <Goldar(a)discussions.microsoft.com> wrote in message
>> news:8340DE38-2350-4158-8EF1-E308D06B2223(a)microsoft.com...
>> > 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
>>
>> .
>>