Widows & orphans

[Andy Stevenson]

I have a report that prints invoices. Some single line entries, some
multiple. At the end of each invoice I've got a page break control to
prevent widows & orphans.



Thing is, if it's only a short invoice I could get 2 on an A4 page. I can't
find a way to control it though. There doesn't appear to be a way that
access will do it, so I'm thinking I'm going to have to monitor the size of
each invoice & slip a page break in if the invoice won't fit on what's left
of the paper. But I'm not sure how to achieve that.



Am I over-thinking this? Is there an easier way? If not does anyone have any
pointers as to how I might go about coding the VBA for this?



Thanks.


Andy

 

[tina]

presumably you've used the Sorting and Grouping dialog box to group each
invoice, using a particular field (InvoiceID, maybe?). go back into the
dialog box and click on the line that shows that fieldname. in the Group
Properties section at the bottom, change the KeepTogether property from No
to Whole Group. remove the page break from the Footer section.

hth

 

[Andy Stevenson]

presumably you've used the Sorting and Grouping dialog box to group each
invoice, using a particular field (InvoiceID, maybe?). go back into the
dialog box and click on the line that shows that fieldname. in the Group
Properties section at the bottom, change the KeepTogether property from No
to Whole Group. remove the page break from the Footer section.

hth

Outstanding! Thank you. Keep Together, makes loads of sense now.

 

[tina]

you're welcome

Outstanding! Thank you. Keep Together, makes loads of sense now.