dbTalk Databases Forums  

Deleting empty pages?

comp.database.ms-access comp.database.ms-access


Discuss Deleting empty pages? in the comp.database.ms-access forum.



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

Default Deleting empty pages? - 09-06-2003 , 09:58 PM






Hello

Let's say...well, this isn't hypothetical, so...in MS Access, I put together
a report, which was pulled from a query, which was, in turn, pulled from a
table.

While I was assembling the report, in design view, I was trying to keep the
printed data on one landscaped page; when it filled the first page, and then
ran onto the second, I finagled the boxes by making them as small as
possible, and as close to one another as possible, so that I might squeeze
all of the data onto a single, landscaped page.

The printed data now fits onto one landscaped page, and looks ok. However,
when I print the report, every other page is blank, possibly due to the fact
that it still "sees" that the data once ran off onto a second page, and
"needs" to continue to print that second page, even if it is blank...?

All of the "borders" that I created have been pulled fully back, and do not
exceed the first page.

How can I print the entire report, without printing it by printing every
individual odd-numbered page, at a time?

Am I making myself clear, here? Kind of hard to explain, without having you
in front of my computer.

Thanks in advance.

smackedass



Reply With Quote
  #2  
Old   
janthony
 
Posts: n/a

Default Re: Deleting empty pages? - 09-08-2003 , 03:32 PM






If you are asking how do you get rid of the blank pages, then there
are a couple things to look for.

1) Look at the properties of the entire report and on the format tab
look for the width of the report.

2) Look for a one of the thin lines that the wizard likes to put in
there as an underline or deviding line and see if a small (very small)
portion of it is trying to print on the next page. (This seems to
happen alot)



Quote:
Hello

Let's say...well, this isn't hypothetical, so...in MS Access, I put together
a report, which was pulled from a query, which was, in turn, pulled from a
table.

While I was assembling the report, in design view, I was trying to keep the
printed data on one landscaped page; when it filled the first page, and then
ran onto the second, I finagled the boxes by making them as small as
possible, and as close to one another as possible, so that I might squeeze
all of the data onto a single, landscaped page.

The printed data now fits onto one landscaped page, and looks ok. However,
when I print the report, every other page is blank, possibly due to the fact
that it still "sees" that the data once ran off onto a second page, and
"needs" to continue to print that second page, even if it is blank...?

All of the "borders" that I created have been pulled fully back, and do not
exceed the first page.

How can I print the entire report, without printing it by printing every
individual odd-numbered page, at a time?

Am I making myself clear, here? Kind of hard to explain, without having you
in front of my computer.

Thanks in advance.

smackedass

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.