address help

[ChrisDo11]

=[company name] & "
" & [po box] & "
" & [street] & "
" & [city] & ", " & [province] & "
" & [postal code]

i'm using the above code to display table feilds in my report(transmittal report). some of the companies don't have PO Box numbers. When this happens i'm left with a space between company name and street. is there a way to "suck up" the rest of the address if there is no PO Box?

thanks.....

 

[Rich]

=[FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address1] & Chr(13) & Chr(10) & IIf(IsNull([City]),"",[City] & Chr(13) & Chr(10)) & [PostalCode]