memo field sometimes cut off in footer

[bicyclops]

A memo box in the page footer of my report most often contains only a few
lines, but sometimes contains very many. I have the CanGrow property turned
on. When it grows too much, it gets cut off at the bottom of the page.

Can I determine if this will happen & format the report so the box gets
pushed to a 2nd page? Otherwise it would be nice if, when the box grows, it
makes the detail section smaller instead (grows up instead of grows down).

 

[Marshall Barton]

A memo box in the page footer of my report most often contains only a few
lines, but sometimes contains very many. I have the CanGrow property turned
on. When it grows too much, it gets cut off at the bottom of the page.

Can I determine if this will happen & format the report so the box gets
pushed to a 2nd page? Otherwise it would be nice if, when the box grows, it
makes the detail section smaller instead (grows up instead of grows down).

The Page Header and Footer sections can not grow.

The Height of the page footer can be reset any time before
the page is started so I think you would need to calculate
the required height in a report header event.

If the page footer text box spans the entire width of the
report, you can use the report method Me.TextHeight

If the page footer text box does not span the entire width
of the report, then calculating the height of the text box
is an extremely complex procedure. See the fTextHeightWidth
topic at www.lebans.com for the code you can use.