dbTalk Databases Forums  

printing a report without blank pages after a record in Access 2007

comp.databases.ms-access comp.databases.ms-access


Discuss printing a report without blank pages after a record in Access 2007 in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
g
 
Posts: n/a

Default printing a report without blank pages after a record in Access 2007 - 06-23-2010 , 12:17 PM






The report is printing some 7 fields from a Table which has 14 fields.
The report gets its data(to be displayed) from a single table only.
In the layout view in Access 2007, it looks fine as I want it. But, in
the Print Preview, I notice there are 2 blank pages after one record.
Also, the first three pages of the report are blank. I deleted the last
record from the table. Could that be causing that? I have closed and
restarted Access 2007, but still the first three pages are blank in
Print Preview.


1. What could be the cause for first three blank pages? How can I fix it?

2. For the 2 blank pages after each record, what can I do to fix it?

Any advice would be welcome.

Reply With Quote
  #2  
Old   
John W. Vinson
 
Posts: n/a

Default Re: printing a report without blank pages after a record in Access 2007 - 06-23-2010 , 03:12 PM






On Wed, 23 Jun 2010 13:17:57 -0400, g <g_1@g.com> wrote:

Quote:

The report is printing some 7 fields from a Table which has 14 fields.
The report gets its data(to be displayed) from a single table only.
In the layout view in Access 2007, it looks fine as I want it. But, in
the Print Preview, I notice there are 2 blank pages after one record.
Also, the first three pages of the report are blank. I deleted the last
record from the table. Could that be causing that? I have closed and
restarted Access 2007, but still the first three pages are blank in
Print Preview.


1. What could be the cause for first three blank pages? How can I fix it?

2. For the 2 blank pages after each record, what can I do to fix it?

Any advice would be welcome.
The most common cause of this is having an explicit "new page" in the report
design - in the report header, the detail section, or some other section.
Check the properties of the report and see if there's anything in the "Force
New Page" property of any of the report sections.

You can get *trailing* blank pages if the size of the page extends into the
margins. Doublecheck the size of the report text area against the size of the
paper minus the left, right, top and bottom margins.
--

John W. Vinson [MVP]

Reply With Quote
  #3  
Old   
g
 
Posts: n/a

Default Re: printing a report without blank pages after a record in Access2007 - 06-23-2010 , 04:17 PM



On 6/23/2010 4:12 PM, John W. Vinson wrote:
Quote:
On Wed, 23 Jun 2010 13:17:57 -0400, g<g_1@g.com> wrote:



The report is printing some 7 fields from a Table which has 14 fields.
The report gets its data(to be displayed) from a single table only.
In the layout view in Access 2007, it looks fine as I want it. But, in
the Print Preview, I notice there are 2 blank pages after one record.
Also, the first three pages of the report are blank. I deleted the last
record from the table. Could that be causing that? I have closed and
restarted Access 2007, but still the first three pages are blank in
Print Preview.


1. What could be the cause for first three blank pages? How can I fix it?

2. For the 2 blank pages after each record, what can I do to fix it?

Any advice would be welcome.

The most common cause of this is having an explicit "new page" in the report
design - in the report header, the detail section, or some other section.
Check the properties of the report and see if there's anything in the "Force
New Page" property of any of the report sections.
Thanks for the advice.

The Force New Page is set to "None" for Report Header, Record Number
Header, Detail, Page Footer, Report Footer. Still, the blank page is
appearing on the first page of report. What else could be causing it?

Quote:
You can get *trailing* blank pages if the size of the page extends into the
margins. Doublecheck the size of the report text area against the size of the
paper minus the left, right, top and bottom margins.
Thanks, I reduced the margins and the trailing blank pages after records
are gone.

Reply With Quote
Reply




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 On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.