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.

Printing Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John B - 11 Mar 2008 15:57 GMT
I have a complex report that has sub reports that are of differing sizes for
different reports.  There is a subform that when it is at the bottom of the
page, a line of text (labels and data fields) prints out with half of each
letter/number at the bottom of one page and, after repeating the heading for
the subform, prints out the bottom half of each letter/number at the top of
the next page.  I have the property of the sub report set to keep together
but this does not work.  I have a the heading repeat set to yes for the
heading of the subform.  I cannot tell it to eject before the subform,
because then it does this to all reports - even when in the middle of a page.
This weird printing happens on the print preview and on both a lazer jet
printer and a hp deskjet.  Any ideas?  
Signature

JB

Golfinray - 11 Mar 2008 18:52 GMT
Right click on the section you want to stay on the page and right click, go
to properties, click on Forcenewpage and set it to before or after section,
whatever you need. On the report and all subreports set can grow and can
shrink to yes.

> I have a complex report that has sub reports that are of differing sizes for
> different reports.  There is a subform that when it is at the bottom of the
[quoted text clipped - 7 lines]
>  This weird printing happens on the print preview and on both a lazer jet
> printer and a hp deskjet.  Any ideas?  
 
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.