Hi,
I have managed to work out how to add new lines into a calculated text
box. However in this text box some of the outcome fields are empty
however when previewing the report it includes the blank fields, so
each section of the report is the same size, my field is set to can
grow/shrink, but I think my inclusion in the code for the calculated
box of all 15 outcomes (I have no choice) is what's causing each
calculated box to be the same size on the report. Is there a way of
making it only select fields where there is text? So some questions
will have three outcomes, and be three lines deep, whereas others with
more outcomes will be larger boxes in preview, at the moment each box
is 15 lines deep regardless of how many of the outcomes actually
contain any text or not.
Thanks for any help that comes my way, I'm not the most well versed
access user.
Oliver