report header to next page 1

[xsnrg]

I have a report where a section header is at the bottom of a page with no detail records. I do have Repeat Section header on so it repeats on the next page with the details...

Question?
How can I hide a header if there is not enough room for any details?


McLean Jones
buddycenters.org
"Believing is Seeing

 

[ordendelfai]

This probably isn't going to help much, but there is a complete solution to this problem in the Access Cookbook by O'Reilly, page 154. The book is worth it's weight in gold to anyone who works in Access, and I'd recommend picking it up. I don't have the time to explain the whole procedure for your question because it does involve a bit of VBA and advanced form work.

~Joel
As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.

 

[GingerR]

did you try KEEP TOGETHER? in the design mode, view the SORTING AND GROUPING screen. click on the header in question. Down below next to KEEP TOGETHER choose WITH FIRST DETAIL or WHOLE GROUP, whichever works best for you.

g