>I have a report that has a memo field in the detail band. How can I force the detail band to start printing on a new page if the memo field of the current record to be printed has X number of lines. I have tried setting the stretch with overflow on but then the layout (i have fields surrounded with boxes) is messed up.
One idea that came to mind: preprocess the file and add a new column to your cursor lNewLine = mlines(myMemo) > myValue Then you can create a group based on lNewLine.. Or may be you can work out this idea without preprocessing.
If it's not broken, fix it until it is.
My Blog