Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / March 2008

Tip: Looking for answers? Try searching our database.

Blank pages between SOME pages

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MeSteve - 10 Mar 2008 16:28 GMT
I have a report where, when viewing unfiltered, SOME records will grow to 2
pages while others still fit on one page.  There is no visible data I can see
spilling over to cause the second page.  Also, it is not for each record in
the report, just some which tells me the margins are OK.

Any ideas what is causing the report to grow to multiple pages?  I have some
boxes that are set to allow grow, but there is more data beneath those boxes
and they remain on the first page.  The only thing on the second pages is the
page header.
MeSteve - 10 Mar 2008 16:38 GMT
The page length was set to too long.

> I have a report where, when viewing unfiltered, SOME records will grow to 2
> pages while others still fit on one page.  There is no visible data I can see
[quoted text clipped - 5 lines]
> and they remain on the first page.  The only thing on the second pages is the
> page header.
Evi - 12 Mar 2008 11:07 GMT
Where is the Page Length set? I use Acc2k and can't see Page Length in
Properties or Page Setup to set that, only the Paper Size, Column Height and
the Height of the different secions.
I'm asking this because I can just imagine someone else having this very
same problem.
Evi

> The page length was set to too long.
>
[quoted text clipped - 7 lines]
> > and they remain on the first page.  The only thing on the second pages is the
> > page header.
DialAround - 13 Mar 2008 16:23 GMT
I never seen this so I'm just guessing . . . there might be some excess
spaces included at the end of the fields that can grow - you could try
"trimmming" those fields to see if that helps.

> I have a report where, when viewing unfiltered, SOME records will grow to 2
> pages while others still fit on one page.  There is no visible data I can see
[quoted text clipped - 5 lines]
> and they remain on the first page.  The only thing on the second pages is the
> page header.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.