I have a report that has a text box, the text box pulls data from a table. This gives the user the ability to change the reports contents (Its a weekly letter).
All is working but since the users text from the table varies and can be longer than 256 the field in the table that populates the text box on the report is a memo field. In the report, this text box pulls data with this data source: =DLookUp("RecallText","tRecallNotes","ID = 1"). In the report I've made the text box fairly small and set the property can grow to YES.
All is working great but I think the text box grows a little too wide and I'm getting a blank 2nd page on the report. When I set the option Can Grow to NO, I don't have an issue. Is there any way to prevent this or to limit the Can Grow property to only grow in height and the width remains locked/fixed?