Address Block Calculation

[LisetteG]

This is perhaps a simple inquiry.

If Address 2 does not exist in a record, how can I tell the calculation to ignore the line break command?

If I have no state (for example if I want to send something to Washington, D.C.), how can I tell the calculation to ignore the comma and space command?

I'm new at this and have tried several things, but have yet to find the solution.

Thank you in advance for your assistance.

[bcooney]

I use the List ( ) function for Addr_Full and I also build a Addr_CSZ calc.

For DC I just let users enter Washington in the City and DC in the State Field.

Addr_CSZ = Addr_City & ", " & Addr_State & " " & Addr_Zip

Addr_Full = List ( Addr_Street1; Addr_Street2; Addr_CSZ)

List will drop out the Addr_Street2 for you if empty.