>Hi
>
>What is the correct syntax for removing carriage return and line feed from a memo field.
>
>Replace memofield with strtran(memofield,?,"") where ? is the bit I can't remember.
>
>Thanks
>
>Colin
Colin,
Use ChrTran() instead of strtran(). chr(13) or chr(10) alone too acts as a linefeed.
replace memofield with ChrTran(memofield,chr(13)+chr(10),'')
Cetin