I am trying to join address line 1 and address line 2 into one field so I can import it back into RE. Becuase RE only allows for address lines I need to have the formual return:

Address 1/nAddress 2

My formula is {address 1}+"/n"+{address 2}

 It works if there is data in {Address 2} but if there is no data nothing is returned. I tried an If Then statement

If {address 2} <> " " then {address 1}+"/n"+{address 2} else {address 1}

 This only returns the combination and not the value  of {address 1} if {address 2} is blank.

 HELP

 You need to use the IsNull() function to determine if the {address 2} field is null.  There is a difference between a null string and a zero-length string.  You're checking for a zero-length string.

Drew