Removing an address field when it contains no data in a report

[Phyllis622]

I created a report to print out a letter that will be sent to all of our clients. In the address section of the letter there are two field for adresses...Address1 and Address2. One is for a street address and the other for a PO Box. Not all of the clients have a PO Box and for these, I do not want the blank line to show in the address. For example:
John Doe
3 Main Street

Franklin, MA 02038

The field and section of the report are set to "can shrink" and "can grow", but it still gives me a blank line in the address for the clients that do not have a PO Box. What else do I have to do?

[John_G]

Are there any other controls to the left or right of the address fields on the report? These can prevent CanShrink from behaving as expected.

[Phyllis622]

No nothing to the left or right. This is what it looks like:

=[FirstName]&" "&[LastName]
Address1
Address2
=[City]&", "&[State]&" "&[PostalCode]

[orange]

Try using + signs instead of &
I think it will remove the "empty" address2

[Phyllis622]

Thanks, I tried the + signs, but it didn't work.

[Phyllis622]

Thank you for the input. I'm not familiar with the expression you are suggesting, can you show me what it would look like? Can I do a TRIM somehow?

[orange]

I found this just now


Using + to concatenate the strings will result in a Null value rather than a
space when needed. For instance,

(StreetNumber + " ") & StreetName

will not have a leading space, since Null + " " = Null
After the parenthesis, the result of the Addition will be Null & StreetName,
which concatenates as you are used to.

here

[Phyllis622]

Right, but can I use this when Address1 and Address2 need to be on separate lines in the report?

[orange]

There is an example here --doesn't use + signs