Printing half of line on one page half on the other

[dpedley]

I have a simple report. The data all comes from one table. The table has about 150 Y/N questions which are answered in a survey format. After the responses are entered a report is created for the individual listing all the yes responses with some lines of additional text. So the report obviously varies in length. The problem is that often at the bottom of the page the last line of text is only printing the top half of the text and the bottom half is printing on the next page. I have tried several ways to account for this and tried every possible combination of forced page breaks I can think of (including removing the footer). It doesn't happen all the time, because the spacing is constantly changing, but other than opening the report structure and modifying the length of the report up a couple of notches, nothing seems to make a difference. And of course eventually this fix will cause a different responder's report to behave the same way. Shouldn't Access account for this itself? Shouldn't it realize that all the text doesn't fit and move the next page?

 

[sxschech]

If it is only one or two lines...What about decreasing the point size of the font. From 10 to 8 for example? Another option is to scale down the report size perhaps from 100% to 95%. Have you adjusted the top and bottom margins to gain additional print area?

 

[dpedley]

thanks for the reply. Unfortunately this doesn'ts work either. These reports can often be several pages long and changing the font size only works as a temporary fix. Eventually some report ends up printing the same way.

Perhaps I wasn't clear. This isn't obvious all the time. Only now and then when a line is printing near the end of the layout. Most times there is some white space (which is probably being cut in half as well, but is obviously not noticable).

Also the user doesn't want or have the option to make modifications on the fly. Each time this occurs I have to go in and change something in the design, print the report for the individual, and then go back and put the design back to it's original form.

 

[Aelonwy]

I am having this same problem too. The little fixes of font correction or other format changes don't work because I have 80 pages and one of these pages is bound to split the text right in half horizontally. Please help me too, I would like to fix this without resorting to a sub report. Thanks!

 

[sxschech]

Not sure if this would work for you and don't have code handy, perhaps you could put in a counter on the report, set it to invisible and use vba to determine if the information is going to be more than a certain number of lines to adjust the page accordingly. Have you also set the can grow/shrink properties for the text boxes? Is there anything on the report that can be rearranged so that you can move the data up?

 

[dpedley]

Thanks for the reply. Due to the nature of the data I don't see how a counter would work. And yest all of the data on the report is set to can grow/shrink. I have tried moving items up and down and around on the report, but eventually, similar to what Aelonwy describes, it will recur. I thought I had heard that this was a known problem and that there was some sort of fix or patch. But I couldn't find one, that actually downloaded and my numerous attempts to contact MS about this have gone unanswered.

 

[KSAccessLady]

I found a solution to this. Instead of making the sub-reports paper thin I increased their height, still allowing to the Grow or Shrink. This fixed the problem for me. Great Site!