Line Break in Labels

[peschu123]

Hi,

instead of using TOTALs in my straight table, I use labels like: ='Bearbeitungszeit ( ' & (sum(Bearbeitungszeit)) &' h )'

Table is format with wrapping of labels in 2 lines.

Is it possible to define fixed line breaks in the above example like (I use <br> html tag to show where the break should be):

='Bearbeitungszeit <br> ( ' & (sum(Bearbeitungszeit)) &' h )'

Thank you very much for any help

[MayilVahanan · Accepted solution]

HI

Try like this

='Bearbeitungszeit ' & Chr(10) &' ( ' & (sum(Bearbeitungszeit)) &' h )'

[peschu123]

Thank you for the ultrafast reply...

It works very well, when the column is bigger than the part before the break ( kinda logic and obviously).

This is great for me. If you have a quick idea how to manage, to set the column width from 0 - Chr(10) it would be great. Even if the second line is longer than first.

That it looks like this:

Bearbeitungszeit

( 200.000 h /Mo..

But I assume this is not easily possible.