Eliminating blank lines in Query and Table records

[Bigdaddrock]

I have created an address field that consists of Address1; Address2; City, State and Zip. When all are populated this would create a three line record. However, when there is no Address2, I would like it to appear as a two line record. What do I need to insert here? Here is what I have used to date:
Expr: Address1 & Chr(13) & Chr(10) & Address2 & Chr(13) & Chr(10) & City & ', ' & State & ' ' & Zip

In Reports I have used the Trim function, but that does not seem to work in Queries and Tables.

Any suggestions??

[ADezii]

I have created an address field that consists of Address1; Address2; City, State and Zip. When all are populated this would create a three line record. However, when there is no Address2, I would like it to appear as a two line record. What do I need to insert here? Here is what I have used to date:
Expr: Address1 & Chr(13) & Chr(10) & Address2 & Chr(13) & Chr(10) & City & ', ' & State & ' ' & Zip

In Reports I have used the Trim function, but that does not seem to work in Queries and Tables.

Any suggestions??

Expr: [Address1] & IIf(IsNull([Address2]),"",Chr(13) & Chr(10) & [Address2]) & Chr(13) & Chr(10) & [City] & ', ' & [State] & ' ' & [Zip]

[ChipR]

You could use something similar to:

Expr: Address1 & Chr(13) & Chr(10) & 
  IIf(IsNull(Address2),"", Address2 & Chr(13) & Chr(10)) & 
  City & ', ' & State & " " & Zip

If no Address2 means the field is null. If it's an empty string, you would use

  IIf(Address2="",...