Can-Grow Field At Bottom Of Page Gets Cut Off (1 Viewer)

[whdyck]

I am using MS Access 2003.

I have a report whose Detail band contains a zero-height Comment field positioned at the bottom of the other single row of fields. It has Can Grow = Yes, so it sits waiting to grow if there's any data in this Comment field. (See attachment 1, where this Comment field's handles are displayed.)

However, when this report prints, if the Comment field just "happens" to straddle two pages, it gets positioned only on the first page and gets cut off in the process. (See attachment 2.) Ideally, the entire field should display on the second page instead.

If I adjust the margins in Page Setup, I can fix this on this particular report. However, depending on the data being reported, these new margin settings can create a problem for the same report with different data. (All depends on where the Comment falls.)

I'd like the report to work consistently, no matter the data or margins. Is that possible?

Or is this just an Access bug I'll have to live with?

Thanks for any help you can give.

Wayne

 

[whdyck]

I discovered that the following works:
- set fldUnitNo as a group in the report, with Keep Together set to Yes
- set the new group header and footer to zero height

It also works if I simply set Keep Together = Yes for the Detail band.

Too simple.

Wayne