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.

Problem with report design

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
deskmonkey - 10 Mar 2008 16:46 GMT
I have the report done and laid out about as perfectly as I can ask for, but
I have one small problem. When the report prints out, the layout looks like a
Word table, with the bottom part of the table actually laid out in the page
footer section, while the rest is in the detail section. All of the lines
I've drawn to simulate a table gridlines line up beautifully from the page
header to the detail section, but there is a small horizontal space between
the detail section and the page footer. I've checked and double-checked all
my measurements, and for legal reasons, this report MUST look the way I have
it. Does anyone know how to eliminate this gap?
scott04 - 10 Mar 2008 19:07 GMT
Can it be as simple as shrinking the area in your page footer?  Otherwise
does this report run off a subreport?  

> I have the report done and laid out about as perfectly as I can ask for, but
> I have one small problem. When the report prints out, the layout looks like a
[quoted text clipped - 5 lines]
> my measurements, and for legal reasons, this report MUST look the way I have
> it. Does anyone know how to eliminate this gap?
deskmonkey - 10 Mar 2008 19:51 GMT
I've tried that, and it only makes my footer section shorter. In the view and
the print, that gap is still there. I've also tried inserting a group footer
and adding very short vertical lines to try to bridge that gap, but they run
off onto the next page.

I hate it when my computer is smarter than me.  =(

> Can it be as simple as shrinking the area in your page footer?  Otherwise
> does this report run off a subreport?  
[quoted text clipped - 8 lines]
> > my measurements, and for legal reasons, this report MUST look the way I have
> > it. Does anyone know how to eliminate this gap?
scott04 - 10 Mar 2008 20:49 GMT
Have you checked the details section All tab for Force new page or New Row or
Col??

> I've tried that, and it only makes my footer section shorter. In the view and
> the print, that gap is still there. I've also tried inserting a group footer
[quoted text clipped - 15 lines]
> > > my measurements, and for legal reasons, this report MUST look the way I have
> > > it. Does anyone know how to eliminate this gap?
deskmonkey - 11 Mar 2008 16:11 GMT
My report has 4 sections in total: page header, group header, detail and page
footer. Of those sections, only the group header has the "Force New Page" set
to something besides None (actual setting is Before Section). The "New Row or
Col" is set to None for both detail and group header.

> Have you checked the details section All tab for Force new page or New Row or
> Col??
[quoted text clipped - 18 lines]
> > > > my measurements, and for legal reasons, this report MUST look the way I have
> > > > it. Does anyone know how to eliminate this gap?
deskmonkey - 11 Mar 2008 17:19 GMT
Ok, figured it out!

You're right - it was the length of the footer. I went back and instead of
adjusting it by dragging the edge of the field, I went into the Properties
field and adjusted it 1/10,000 of an inch at a time. It took a while, but the
gap is now gone. Thank you!

> Have you checked the details section All tab for Force new page or New Row or
> Col??
[quoted text clipped - 18 lines]
> > > > my measurements, and for legal reasons, this report MUST look the way I have
> > > > it. Does anyone know how to eliminate this gap?
scott04 - 11 Mar 2008 18:55 GMT
Glad everything worked out for you

> Ok, figured it out!
>
[quoted text clipped - 25 lines]
> > > > > my measurements, and for legal reasons, this report MUST look the way I have
> > > > > it. Does anyone know how to eliminate this gap?
 
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.