Header and/or footer should be suppressed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rmcompute - 23 Dec 2005 23:06 GMT

I have a report which is sorted by Branch. When Branch changes the title and
header are printed on the page. All of the detail records are complete on
one page, however the report prints the title and header on the next page
with no detail records. Is there anyway to suppress a header and/or footer
if there are no more detail records ?

Reply to this Message

Marshall Barton - 24 Dec 2005 03:10 GMT

>I have a report which is sorted by Branch. When Branch changes the title and
>header are printed on the page. All of the detail records are complete on
>one page, however the report prints the title and header on the next page
>with no detail records. Is there anyway to suppress a header and/or footer
>if there are no more detail records ?

Reports don't print an extra page with a header unless you
do something to tell it that's what you want.

If you have a group footer section, make sure its
ForceNewPage property is not set.

Signature

Marsh
MVP [MS Access]

Reply to this Message

rmcompute - 24 Dec 2005 16:31 GMT

Force New Page is set to None, but the report prints a header and footer on the
next page when the number of records contained in the branch is exactly the
amount that fits on one page. If it is less, this does not happen and if it
is more, the header and footer do print as they should on the next page with
the detail records. Is there a way to stop the header and footer from
printing when the amount of records per branch is exactly the amount that fit
on one page, possibly some event could be used ?

> >I have a report which is sorted by Branch. When Branch changes the title and
> >header are printed on the page. All of the detail records are complete on
[quoted text clipped - 7 lines]
> If you have a group footer section, make sure its
> ForceNewPage property is not set.

Reply to this Message

Marshall Barton - 24 Dec 2005 18:58 GMT

No, there is event for this kind of thing because the
situation should not come up.

There must be something to print on that "extra" page. The
most likely is to check for extra space below the lowest
control in the detail section. If you are having trouble
identifying the source of whatever is spilling over to the
next page, try setting each section's and the lowest
control's BackColor to various colors so you can see some
kind of indication of what's going on.

Signature

Marsh
MVP [MS Access]

>Force New Page is set to None, but the report prints a header and footer on the
>next page when the number of records contained in the branch is exactly the
[quoted text clipped - 15 lines]
>> If you have a group footer section, make sure its
>> ForceNewPage property is not set.

Reply to this Message