 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / May 2006How do I get rid of empty space on my report?
This is just a simple report.....use a query to list customer information. Each customer has 3 or 4 lines. There's a title in the page hdr area. There's 4 lines of customer info in the detail area with a straight line under it so the customers will be separated. The line is in the detail area. The page number is in the footer. When you display the report the first customer prints fine, right up under the title (or page header). But there is one whole line of space after the line under the first customer, before the next customer prints. I just can't figure out where this blank line (or space) is coming from. All of the customer detail fields are all squished up to together. There is no blank space between the detail border and the footer border. In fact if I try to move them up, they flip up to the header area. The report is almost 300 pages long so eliminating this blank space could be very helpful. Any suggestions to get rid of this space would appreciated. Thanks, >This is just a simple report.....use a query to list customer information. >Each customer has 3 or 4 lines. There's a title in the page hdr area. [quoted text clipped - 10 lines] >no blank space between the detail border and the footer border. In fact if I >try to move them up, they flip up to the header area. It sounds like you have some blank space after the line in the detail section. Try dragging the the bottom of the section up to the line. If that doesn't help, you can set the back color of each section to a different color so you can identify where the space is coming from.  SignatureMarsh MVP [MS Access] Good Idea! I did that and the extra space is in the detail section. For 2 of the address lines, I used the CanShrink (yes). Is it possible this has something to do with it?? It's almost like, the amount of space for each customer has to be the same. Like the address lines themselves will adjust up when there's not a second address line, but overall each specific customer is alotted the amount of space specified by the detail area of the report. Could this be or am I way off base?? > >This is just a simple report.....use a query to list customer information. > >Each customer has 3 or 4 lines. There's a title in the page hdr area. [quoted text clipped - 18 lines] > section to a different color so you can identify where the > space is coming from. I thought the extra space was after the horizontal line, but if it's up in the address area, then I think it likely that you forget to set the details section's CanShrink property to Yes. SignatureMarsh MVP [MS Access] >Good Idea! I did that and the extra space is in the detail section. >For 2 of the address lines, I used the CanShrink (yes). Is it possible this [quoted text clipped - 27 lines] >> section to a different color so you can identify where the >> space is coming from. It's the weirdest thing....the space is at the top, before the first line of each detail section. The first person prints great. The name is right up under the page header. The address shrinks like it's supposed to. It's the second and rest of the customers on the page that have the blank space. In fact, the first person on each page prints right. Like this..... bottom line of the hdr ============================ 1st name line Name Name2 (canshrink) Address Address2 (canshrink) City, State, Zip Line in detail ____________________________ (right up under the words) Next person >>>>>> space 2nd name Name Name2 Address City, State, Zip _________________________________________ From the second person on, there's that space before the name (the name2 and address2 shrink correctly). Why would the first person print okay and not the rest??? I am stumped. > I thought the extra space was after the horizontal line, but > if it's up in the address area, then I think it likely that [quoted text clipped - 31 lines] > >> section to a different color so you can identify where the > >> space is coming from. The only reason for that effect is if the bottom of the detail section is that amount of space below the line. Try dragging the top edge of the section bar below the detail section up into the detail section. It will then snap down to the highest point in the detail section it can and still display all the controls in the detail section. If that point is not right up against the line, it implies that there is a control below the line and you should drag a selection in the left side ruler form just below the line down into the next section bar to highlight the problem control. SignatureMarsh MVP [MS Access] >It's the weirdest thing....the space is at the top, before the first line of >each detail section. The first person prints great. The name is right up [quoted text clipped - 57 lines] >> >> section to a different color so you can identify where the >> >> space is coming from. Thank you! Thank you! Thank you! I found it!! :) Can I send you cookies!! > The only reason for that effect is if the bottom of the > detail section is that amount of space below the line. Try [quoted text clipped - 70 lines] > >> >> section to a different color so you can identify where the > >> >> space is coming from. While cookies are a very nice thought, I'm happy with just a "Thank you, that solved it" or, if you are really excited, a "My Hero" ;-)) SignatureMarsh MVP [MS Access] >Thank you! Thank you! Thank you! I found it!! :) Can I send you cookies!! > [quoted text clipped - 72 lines] >> >> >> section to a different color so you can identify where the >> >> >> space is coming from. |
Reply to this Message |
 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.