Hi everybody, I am new to access and have a problem with my report printing extra pages that contain no data on them. I have a report with multiple subforms that can grow and shrink as needed. The problems is that the report may span 1-2 pages, depending on the information entered by the user of the system, and the last subreport on the report has a fixed height for user notes. This creates a problem because that section, in many cases, could shrink a line or two and have the report fit into one single page. Any suggestions or fixes would be greatly appreciated! Thank you and have a nice day!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SIZE Matters! Reports/Subreports need to fit onto 1 page Save Trees!
- Thread starter eatwork
- Start date
check this - page set up. Look at your margins and measure your paper (portrait or landscape) account for those margins, lessen if you can. Then with the space left. Make sure that you look at the ruler at the top and bottom. Dont make the report and sub line up, make their ruler amounts line up. If the horizantal of the page for the main report goes to 7", only let the sub go to 7". If you need more help, let me know.
misscrf
It is never too late to become what you could have been ~ George Eliot
misscrf
It is never too late to become what you could have been ~ George Eliot
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question