472,956 Members | 2,681 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,956 software developers and data experts.

Blank pages in a report

I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry
Nov 13 '05 #1
6 4621
no***@here.com wrote:
I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry


Check your page size. The fields may exceed the length of your column
(File/PrinterSetup)

Make sure your fields placement don't exceed the column width.
Nov 13 '05 #2
Hi there,

Maybe a natural page break is occurring within a line or two of your page
break control. Suggest
removing your page break control and see what happens.

HTH -Linda
<no***@here.com> wrote in message
news:72********************************@4ax.com...
I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry

Nov 13 '05 #3
Thanks, but that was the first thing that I checked. The column size
is good and is smaller that the page width.

On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.com> wrote:
no***@here.com wrote:
I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry


Check your page size. The fields may exceed the length of your column
(File/PrinterSetup)

Make sure your fields placement don't exceed the column width.


Nov 13 '05 #4
Linda,

The does not print out any blank pages when the page break is removed.
There is group header on the report based on the field ClientNumit is
grouped on each value and keep together is set to yes. The problem is
that while most pages will seperate correctly, that is each page will
start with a new ClientNum and grouyp header, some pages will have
part of the previous page before the group header. That is why I put a
page break on the report. It solved that problem but now creates this
new one.

Harry
On Sun, 30 Jan 2005 11:48:18 GMT, no***@here.com wrote:
Thanks, but that was the first thing that I checked. The column size
is good and is smaller that the page width.

On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.com> wrote:
no***@here.com wrote:
I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry


Check your page size. The fields may exceed the length of your column
(File/PrinterSetup)

Make sure your fields placement don't exceed the column width.


Nov 13 '05 #5
I'd recommend losing the page break and setting your group header's
ForceNewPage property to Before Section.

<no***@here.com> wrote in message
news:7m********************************@4ax.com...
Linda,

The does not print out any blank pages when the page break is removed.
There is group header on the report based on the field ClientNumit is
grouped on each value and keep together is set to yes. The problem is
that while most pages will seperate correctly, that is each page will
start with a new ClientNum and grouyp header, some pages will have
part of the previous page before the group header. That is why I put a
page break on the report. It solved that problem but now creates this
new one.

Harry
On Sun, 30 Jan 2005 11:48:18 GMT, no***@here.com wrote:
Thanks, but that was the first thing that I checked. The column size
is good and is smaller that the page width.

On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.com> wrote:
no***@here.com wrote:

I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry

Check your page size. The fields may exceed the length of your column
(File/PrinterSetup)

Make sure your fields placement don't exceed the column width.

Nov 13 '05 #6
Thanks alot.
That seems to do the trick. I will have to do some more testing but I
think it will be good.

Thanks again,
Harry

On Sun, 30 Jan 2005 12:29:27 GMT, "MacDermott" <ma********@nospam.com>
wrote:
I'd recommend losing the page break and setting your group header's
ForceNewPage property to Before Section.

<no***@here.com> wrote in message
news:7m********************************@4ax.com.. .
Linda,

The does not print out any blank pages when the page break is removed.
There is group header on the report based on the field ClientNumit is
grouped on each value and keep together is set to yes. The problem is
that while most pages will seperate correctly, that is each page will
start with a new ClientNum and grouyp header, some pages will have
part of the previous page before the group header. That is why I put a
page break on the report. It solved that problem but now creates this
new one.

Harry
On Sun, 30 Jan 2005 11:48:18 GMT, no***@here.com wrote:
>Thanks, but that was the first thing that I checked. The column size
>is good and is smaller that the page width.
>
>
>
>On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.com> wrote:
>
>>no***@here.com wrote:
>>
>>> I have greated a report and have included a page break in it. The
>>> report breaks were it is supposed to but then it creates a blank page
>>> between the two pages. Since this report will print out approx 20
>>> pages (without the blank pages) it is large waste of paper. I have
>>> tested the report by setting the data source so that only one page
>>> will print and all the data fits on page. I have checked all the
>>> printing parameter, set the print magins and made sure that the report
>>> fits on one page.
>>>
>>> ANy ideas as to what I can do?
>>>
>>> Thanks Harry
>>
>>Check your page size. The fields may exceed the length of your column
>>(File/PrinterSetup)
>>
>>Make sure your fields placement don't exceed the column width.


Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: L Mehl | last post by:
Different users of the app will want or not want to see report footer ( appears as a separate page). I can make the section invisible with a DLookup of a Y or N value from a 'parameters' table ...
6
by: Melissa | last post by:
Does anyone have a generic procedure for adding blank lines to reports like Sales details, PO details and/or Orders details. The procedure would need to count the number of line items, determine...
4
by: Nhmiller | last post by:
Access seems to always generate a second page, which is blank, to my one page report. How do I delete the second page? Thanks. Neil Cat Paintings At Carol Wilson Gallery...
4
by: Robert McClenon | last post by:
I am having a minor but annoying problem with some reports in Access 2003. (I had the same problem with Access 97, so it isn't version-dependent.) Some of the reports that I originally developed...
2
by: Raul Medina | last post by:
I am trying to print the same visual basic report multiple times in my VB 6.0 application using the command <reportObject>.printReport False, rptRangeAllPages. The only thing that differs between...
1
by: Karen Hill | last post by:
X-No-Archive:yes I have a report that when I view it gives me a blank page after a page with data. For example in the footer, it says I have 2 pages (page 1 of 2), yet when I use the arrow key...
1
by: jj | last post by:
I created a dynamic report and the fields is displayed base on the query. The report contains about 34 fields so if the query has 34 fields, all 34 fields in the report shows up. But if the query...
4
by: Mal Reeve | last post by:
Hello, I have a report that has only 2 levels of grouping. The detail section is simply 1 large block for a memo field. I am finding that on some occasions the report errors and generates...
1
by: maryanncanor | last post by:
Hi everyone, My problem is whenever I export a report to a textfile. The output textfile have blank spaces. Here is my query: SELECT ( & '|' & & '|'...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.