Print text field on multiple lines

[LadyInRed]

Due to limited space on a report, I have shrunk the size of the box containing certain text fields in the Design view. When the report is generated, the field is truncated when the actual data exceeds the size available for printing. Instead, can I get the extra characters to print on another line below the 1st string of characters for the field?

For example (What I want):

First Name Last Name Address ...........
Theodore O'Connell-Lette 1254 Buckinham Ln
rman
Sean Thomas 877 E. Second St
Elaine Hopkins 5662 Forest Glen Rd

 

[scriverb]

Yes, just change the CanGrow property to Yes.

That should do it.

Bob Scriver

 

[LadyInRed]

Thanks so much!

 

[scriverb]

Glad to be of assistance to you.

Bob Scriver

 

[LadyInRed]

Help! I just tried setting the CanGrow setting in Properties for the contol, and it didn't work. My text field is still concatenated. CanShrink is set to No (I tried setting it to Yes as well, but still the same result). Is there anything else I should be looking for in Properties?

Thanks!

 

[LadyInRed]

Sorry about my last thread. I spoke too soon about my field being concatenated. My text field was concatenated due to the maximumm field length specified in my table design. When I tried the CanGroe in a different report, it worked just fine. Again, many thanks!