Auto expand report fields for long text
I need a report with 2 fields that vary in length (from a couple of lines to several pages depending on how much info in contained in the fields). I am attaching MS Access report page for reference. I want 2 things to happen: 1) for each field to grow or shrink depending on the data. & 2) permit those fields to flow to a 2nd (or 3rd) page if necessary. As you see, the 2 fields of interest are separated by a text field (not necessary) & both fields have adjusted to fit the content.
I have searched "everywhere" on web & forums for this & only found shirnking or sliding, neither of which serve my purpose.