How do I create multiple lines in a text field?

[former_member279138]

I am creating a report that features a cross tab. For the columns I am using a field with a few members that each have somewhat lengthy names. This makes my columns way bigger than they need to be and the forces the report onto a second page. Is there a way to format the text in the field so that the column will become two lines that way I can fit the entire name of the field in the column without over stretching the column width?

Thanks

[Former Member · Accepted solution]

Yes  Use a formula to break the text field into is components or Test the length of the string.  then add a  " Carriage return"     where you want to force the second line.    

   The formula will look something like    {field name} +  CHR(13) + {fieldname}  

The chr(13)    will force the Carriage return   ( like an old manual Typewriter for those us us old enough to have actually used one ) 

Ted

[abhilash_kumar]

Hi Kurt,

Do you have an example of the long string and how you'd like to force the breaks?

P.S: this could get very complicated if you're using a non-proportional font.

-Abhilash