Specifying a new line in the formula editor

[Delboy14]

I am printing out several lines of text depending on values in a database. e.g.

if x=1 then text:="The current value of x is 1"
if y=1 then text:=text + "The current value of y is 1"

How do I specify a new line in the formula editor. Is there a new line character (like /n in Visual C)?

 

[hbaake]

Try:
"hello" + chr(13) + "world"

Hugo.

 

[linda105]

Try using the Ascii 13 for a new line

eg. select product + CHAR(13) + product_grade