Yep, both of them worked! Thanks for the help!

Steven Kuhn
Programmer/Analyst
Dept of Residence Life, UW Oshkosh

>Hi!
>
>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.
>
>HTH.
>
>>I know you can you use ALLTRIM() & TRIM() on character expressions to trim blanks off, but it does not work for a memo field. How do you go about trimming blanks off of a memo field? Thanks!
>>
>>Steve Kuhn