View Single Post
 
Old 02-02-2023, 02:46 PM
Charles Kenyon Charles Kenyon is offline Windows 11 Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by Ddadoo57 View Post
when we use the formula field with just a few words, for the text to be displayed, it works very well.

the problem comes when there is a lot of text, like in my case.

A vba solution, might be to dynamically enlarge the bottom margin height of the last page, but I don't know how to do this dynamically, automatically.

You do not need to increase the bottom height of the footer. The area allocated to it will expand to fit whatever content you insert. A problem comes with the IF field, though, if the content inserted more than fills the last page (creating a new last page).
Reply With Quote