linebreak in long text

[Former Member]

Hello,

I am preparing a default text for a textbox like this:

="Guten Tag Herr "&@name&",

Ihr Darlehensantrag wurde geprüft und bewilligt.

foobar..."

What is the trick to insert linebreaks ?

(the

in the example does not work...)

Thanks,

Kai

[Former Member · Accepted solution]

Hi Kai,

[Here|;

If it is just " " then it is CHR(10).

Good Luck,

Dharmi

Edited by: Dharmi Tanna on Sep 17, 2008 1:07 PM

Edited by: Dharmi Tanna on Sep 17, 2008 1:07 PM

[Former Member · Accepted solution]

Thanks a lot, the CHR does the trick.

=REPLACE("foo ## bar", "##", CHR(10))

replaces all occurences of ## (custom newline-placeholder) with the ascii-code 10 which is New Line / Line Feed.

Thanks!

Kai