Thanks Fred! That works great. In the memo I don't have all the line breaks, thought it might be easier to read here.
>>Yet another basic question..... I would like to print the following in a report but would like to store the string in a memo field for easier editing. Placing it into a field on the report simply posts the text and doesn’t translate the functions. How should I best do this? Thanks!
>>
>>
>>"I regret to inform you that your Sole Source of Heat permit " ;
>>+ "expired on June 30th " + alltrim(str(year(date())))+". " ;
>>+ "Unless you come into our office at 301 W. Alder and renew " ;
>>+ "your permit by " + DTOC(DATE() + 14) ;
>>+ ", your permit cannot be renewed. Please take care of this " ;
>>+ "matter as soon as possible."
>>
>
>In the expression field of your report, you could put this:
>
>EVAL(CHRTRAN(memofield,";"+CHR(13)+CHR(10),""))
>
Jim Philippi
quando omni flunkus moritati