In my Clients table I have BulkPostagePermit field (memo) which contains 2 lines like these:
Anaheim, CA
Permit NO.40078
The whole Postage thingy on the report should look like:
___________
PRESORTED
STANDARD
U.S.POSTAGE
PAID
ANAHEIM, CA
PERMIT NO.49093
______________
Note that some of the clients have this field empty(NULL or ""
I don't want to type the whole thing - 6 lines over and over for each client because 4 top lines are always the same.
How do I insert the top part into the textbox on the report if this BulkPostagePermit is not NULL or empty.
If it is NULL - nothing should be displayed in this box.
Thank you.
Anaheim, CA
Permit NO.40078
The whole Postage thingy on the report should look like:
___________
PRESORTED
STANDARD
U.S.POSTAGE
PAID
ANAHEIM, CA
PERMIT NO.49093
______________
Note that some of the clients have this field empty(NULL or ""
I don't want to type the whole thing - 6 lines over and over for each client because 4 top lines are always the same.
How do I insert the top part into the textbox on the report if this BulkPostagePermit is not NULL or empty.
If it is NULL - nothing should be displayed in this box.
Thank you.