Optional second report page based on field contents and control si

[Carl Rapson]

I have a report based on a paper form. On the report is a textbox control
bound to a Memo field. The form is a single page, and the textbox control has
Can Grow set to No so that the resulting form comes out on one page. But
there are cases where the contents of the Memo field exceed the size of the
textbox, and I have been requested to display the entire contents of the Memo
field. I hate to simply set Can Grow to Yes, because that would redesigning
the form to allow for a second page. Before I do that, I had another thought.

My thought is to somehow determine if the contents of the Memo field will
exceed the size of the textbox control, and if so display the Memo field on a
second report page (with the textbox on the first page containing something
like "See page 2"). I know I could show the textbox on a second page for all
cases, but when the contents are small I would like to keep the form on a
single page if possible.

Is there a way to compare the contents of a field with the size of a control
in this way? How would I then set up the second report page as optional so
that it only shows in these situations? Any suggestions would be most welcome.

Thanks,

Carl Rapson