paragraph mark in a formula

[rhper14]

In Crystal 8.5, how can I write a formula to insert a paragraph mark/return between two strings. I am doing FIELD1 + FIELD2 and I want it to print as

"FIELD1 might say something
FIELD2 continues here"

versus

"FIELD1 might say something FIELD2 continues here"

I have Can Grow turned on, but it word wraps at some odd places, so I want to be able to force it to wrap/break where I want.

 

[lbass]

Try:

{Field1} + chr(13) + {Field2}

-LB

 

[synapsevampire]

Also be aware that CR 8.5 and below will only allow 254 characters max.

A workaround is to drop the first field into a text object, create a formula that reds something like:

if not(isnull({table.field2}))
and
{table.field2} <> &quot;&quot; then
chr(13)

Drop this formula in after the 1st field, and then drop the 2nd field in.

This alleviates either field or in combination exceeding 254, and will not insert a carriage return if the second field is empty.

-k