Thanks actiontech, but I tried to do a Mass Update on a single record, and @Replace (FieldName,@CHR(10)," ") does not work. Don't see how @Replace (FieldName,@CHR(10),@CHR(8)) will work.
Or maybe I am misunderstanding?
Are you saying to add a new temp multiline field.
Then make that new multiline field the existing text field value with the ^J.
And then try the @Replace, and send it back to the text field.
Like this:
NewMultiLineField = TextField
TextField = @Replace(NewMultiLineField,@CHR(10),@CHR(08))
OR
NewMultiLineField = @Replace(NewMultilineField,@CHR(10),@CHR(08))
TextField = @FormFieldValue("FormName","NewMultilineField",0)
Then remove the temp new multiline field?