Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field on a report
Message
From
17/04/2001 15:04:11
 
 
To
17/04/2001 14:47:59
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00496285
Message ID:
00496299
Views:
8
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform