Hello Vlad and Eric,
Vlad suggested:
>Does following command works for you?
>alltrim(strtran(MyMemoField,chr(13),''))
>You can use also
>alltrim(strtran(MyMemoField,chr(13)+chr(10),''))
>in case 2 characters used (CR and LF) as a new line.I think that either of these will remove intentional new lines embedded in the memo field. My take on Eric's request is that excess trailing CR / LF / spaces need to be trimmed off. I've seen code that does this, but sorry to say don't have it handy right now.
Randy Bosma
VFP - Because life is too short to code in something else...