Concatenate but don't display field if blank

[Aerowolf]

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

 

[Falcon99]

Try Conditional If

... [ADDRESS1] & IIF([ADDRESS2]="","",Chr(13) & Chr(10) & [ADDRESS2]) & ...

 

[GHolden]

Just as a note, use vbCrLf instead of Chr(13) & Chr(10)

eg.

=[COMPANY] & vbCrLf & [ADDRESS1]

it's much faster to execute.

There are two ways to write error-free programs; only the third one works.

 

[Aerowolf]

This worked great!!

The vbCrLf did not work however. I'm using Access2000 and I put this expression right in the Control Source property of the text box.

Edwin