Indicate Paragraph in Text Object

[kkorynta]

Hello,

I'm sure there's a command to do this, however, I'm having trouble finding it.

I'm setting up some messages using the text object. What would be really convenient is if there was a way to indicate that the line should be on a new row. Is there a way to do this?

[prieper · Accepted solution]

In a normal text-box each carriage-return (ENTER) will start a new line.
In composited messages, which do include calculations you may include the ENTER between apostrophs:

='Today is: ' & DATE(TODAY()) & '
Tomorrow is: ' & DATE(TODAY() +1)

HTH
Peter

[kkorynta]

Ahh brilliant!

Didn't think of it that way. Thanks!

[#4]

chr(13) is the command for carriage return

eg. ='FirstLine'&chr(13)&'SecondLine'

gives

FirstLine

SecondLine

[georgina_spary]

Hi Christian

I've tried chr(13) and using text strings and neither is recognised by our two main browsers - just get one big block of text. Any ideas?

I'm on QV9 using AJAX - it looks fine in development, displays OK in IE, but just displays wrong through Google Chrome & Firefox