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

One way would be to loop through your sheet after the new record has been found and every time it finds the end of a record then increment a counter.
Use an If statement to check when the counter = 3 and the Then statement will insert a page break.

It wasn't clear if you wanted an extra blank page at the end of your printout or if you are getting an undesired blank page.