Page break

M

Matt Dawson

Having listed a page break to rank by a relative field, I now get a blank
sheet at the start of every report.
Any idea of how to rid this?
Many thanks,
Matt
 
M

Marshall Barton

Matt said:
Having listed a page break to rank by a relative field, I now get a blank
sheet at the start of every report.
Any idea of how to rid this?


Try setting the Report Header section's ForceNewPage
property to Before Section.

If that doesn't take care of it, you can add a Page Break
control near the top of the Report Header section.
 
M

Matt Dawson

I dont have a report header! I had to put a page header in, in order to make
the title appear on every page.
Now i have just the header but without data and this starts on the following
page
Matt
 
M

Marshall Barton

It appears that I have completely misunderstood your
question. Could you provide more details about what the
report has in it and what it does or doesn't do?
 
M

Matt Dawson

Marsh,
Apologies for being vague. I have a report grouped by Agent ID who have
information on all their related sales. I have inserted a page break so that
every agent appears on a new page and also placed my Report header within my
page header in order to get this to appear on every page.
However, I now get one blank page at the start with just the page header.
Does that now make sense?
Many Thanks,
Matt

Marshall Barton said:
It appears that I have completely misunderstood your
question. Could you provide more details about what the
report has in it and what it does or doesn't do?
--
Marsh
MVP [MS Access]


Matt said:
I dont have a report header! I had to put a page header in, in order to make
the title appear on every page.
Now i have just the header but without data and this starts on the following
page
 
M

Marshall Barton

Matt said:
Apologies for being vague. I have a report grouped by Agent ID who have
information on all their related sales. I have inserted a page break so that
every agent appears on a new page and also placed my Report header within my
page header in order to get this to appear on every page.
However, I now get one blank page at the start with just the page header.


Try removing the PageBreak control and, instead, set the
agent group header section's ForceNewPage property to Before
Section. If you do not have a group header section, create
it and make it very small.
 
M

Matt Dawson

Marsh,
That did the trick and it is much appreciated
Many thanks my friend,
Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top