Hi Jon,

I just tried the Replacy with both CHR(13) and CHR(10) and it works just perfectly! That is, it puts everything on one line for that field.

I would not have thought CHR(10) was added since I didn't specifically code it in.

In any event, you have helped me a great deal!

Thanks,

>Hi Jon,
>
>Thanks for the reply.
>
>I have tried the Replace command and have not had any luck with it. The address field still appears on two lines instead of on one line.
>
>Thanks,
>
>>>How do I do that in the Crystal Formula Field editor? What is the syntax?
>>
>>Terry,
>>
>>You would still use Crystal's Replace function to transform the cr/lf to a space:
>>
>>Replace(sourcestring, chr(13)+chr(10), "")
>>
>>Laterness,
>>Jon