Re: In MS Access how can I skip to the next page on section break if section can not be printed entirely



cheyennemtnman wrote:

In MS Access how can I skip to the next page on section break if
section can not be printed entirely on the preceding page. Say if I
had 20 print lines on the page and I have section 1 with 4 records and
section 2 with 5 records ... Section three has 10 records... I want to
print page one with section 1 and 2 since section 3 can not be printed
entirely on the page. Therefore I want it to do a page break before
starting to print the records in section 3...
Is there a simple solution without counting lines?

Check your KeepTogether property.

You can also check MoveLayout, NextRecord, PrintSection Properties in Help when you need to get fancy.

.