Click to See Complete Forum and Search --> : Paragraph Options


jacquie
June 1st, 2007, 11:40 AM
I have solved my code problem but I cannot get it to linefeed
I am using basic syntax. Here is what I have

formula = ""
if {Dealer_Alert_Query.DEALER CONSUMER LETTER} = true then
formula = formula + "Paragraph 1" + "Paragraph 4"
end if
if {Dealer_Alert_Query.Design} = true then
formula = formula + "Paragraph 2" + chr(10) + "Paragraph 5"
end if
if {Dealer_Alert_Query.DlrComplaint} = yes then
formula = formula + "Paragraph 3" + "Paragraph 6"
end if

It will print everything it should up until it encounters the chr(10). I have also tried chr(13) and I have tried & instead of +.

What am I doing wrong?

JaganEllis
June 2nd, 2007, 08:46 AM
Do you mean that you can only see everything up until the chr(10) or chr(13)?
Maybe your field doesn't have the 'Can Grow' option ticked. Look for it in the format options of the field, I can't remember which tab it's on.