Aerowolf
Programmer
- Nov 6, 2002
- 64
I want to print a shipping label. I have 3 address fields.
I need to be able to print all 3 but would rather not print address2 or 3 if they are blank.
Here's my expression so far:
=[COMPANY] & Chr(13) & Chr(10) & [ADDRESS1] & Chr(13) & Chr(10) & [ADDRESS2] & Chr(13) & Chr(10) & [ADDRESS3] & Chr(13) & Chr(10) & [CITY] & ", " & [STATE/PROV] & " " & [ZIP]
Right now if ADDRESS2 or 3 are blank I get blank lines where they would be. Is there a way to not show these fields if they are blank?
Thanks
Edwin
I need to be able to print all 3 but would rather not print address2 or 3 if they are blank.
Here's my expression so far:
=[COMPANY] & Chr(13) & Chr(10) & [ADDRESS1] & Chr(13) & Chr(10) & [ADDRESS2] & Chr(13) & Chr(10) & [ADDRESS3] & Chr(13) & Chr(10) & [CITY] & ", " & [STATE/PROV] & " " & [ZIP]
Right now if ADDRESS2 or 3 are blank I get blank lines where they would be. Is there a way to not show these fields if they are blank?
Thanks
Edwin