Dynamically change text box size

[MrE2811]

I have a report that prints text from a query based on user response. Basically the report becomes a narrative of the data entered. Here is an example:
Trial: IIf([A-Lead]="no"," ","An atrial lead model "+[tblICDBiVent].[A-LEAD MANU]+" serial number, "+[tblICDBiVent].[A-LEAD SERIAL]+" was positioned in the right atrial appendage.")

As you can imagine the data in the text box can be very verbose. My problem is this:

The contents of one of the text boxes has changed. It used to be a paragragh now it can be a mere sentence based on user input. On the report I assigned enough space for a paragraph but if it's a sentence I get left with a big space in the middle of the document. Is there a way I can change the format dynamically based on the data in the text box?

Please let me know if I need to clarify.

Thanks in advance

 

[dhookom]

You can use the Can Grow and Can Shrink properties of text boxes to automatically resize vertically based on the amount of data.


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Crowley16]

there is a canGrow and canShrink property you can mess about with against each text box...

--------------------
Procrastinate Now!