>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."
>
There may be a better of doing this but I think you are going to have to use STRTRAN(). You can place a tag name like ~year and use STRTRAN() to search for it and replace it with the year. The StrTran() can be nested.
?STRTRAN(m.memo,'" + alltrim(str(year(date())))+"',TRANSFORM(YEAR(DATE())))
?STRTRAN(STRTRAN(m.memo,'~year',TRANSFORM(YEAR(DATE()))),'~date14',TRANSFORM(DATE()+14))
Hope this helps.
Fred Lauckner
You know, it works on my computer. I don't know what your problem is.
.Net aint so bad.