Forcing page breaks in a report

[jgarnick]

I have a report that I need to print 40 records per page.&nbsp;&nbsp;I have a invisible counter in the detail section along with a name field.&nbsp;&nbsp;I followed the instructions from Help using Visual Basic to force a page break and the first page looks great!&nbsp;&nbsp;However, for some reason the 2nd page prints only one name and it's in the second column and that is it!&nbsp;&nbsp;The list continues on the third page but leaves the first space in the first column blank (where the name from the second page should be!) I have no idea why this would be happening--anyone?&nbsp;&nbsp;Is there a better way to print only 40 records per page?<br><br>Thanks! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[DougP]

If you know you always want 40 records and they take up the same amount of space say 7.5&quot; then make your top margin and or bottom margin bigger to get just those amount on a page.<br>Preview it and then keep changing you margins to get it right.<br>If your data is variable this won't work. Like you have a Memo field that the number of lines varies.<br>Also <br>Have a Look at my award winning FAQ too for Printer tips here on Tek-Tips.<br><br><A HREF="

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=2562106&CFToken=52712873#14"

TARGET="_new">

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=2562106&CFToken=52712873#14</A>

<p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[jgarnick]

Talk about not seeing the forest for the trees.......works fine increasing the bottom margin...duh!&nbsp;&nbsp;Thanks! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>