Skip to Content

How do I create multiple lines in a text field?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 15, 2015 at 09:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 05:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded