View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sue74 sue74 is offline
external usenet poster
 
Posts: 1
Default Printing a Report


Hi All:

I am trying to create a log for a client, which when they hit a button
inserts a new record at the top of the page and everything is working
fine except when they try to print it, one page can hold 3 full records
but when they enter the 4 th record it gets divided, so one half of the
record is on one page and the second part is on the second page.

I need a way to force a page break after 3 records in every page. Also
when it inserts new records it automatically creates a blank page at
the end.

If anyone can help me on this issue, it would be great.

Sue


--
sue74
------------------------------------------------------------------------
sue74's Profile: http://www.excelforum.com/member.php...o&userid=21685
View this thread: http://www.excelforum.com/showthread...hreadid=381375