code to start a new line in an expression

C

cacacaconnie

I am trying to write an expression that will bring together my address, city,
state, and zip. I need the code that will start a new line after the address,
any help is appreciated. Thanks
 
F

fredg

I am trying to write an expression that will bring together my address, city,
state, and zip. I need the code that will start a new line after the address,
any help is appreciated. Thanks
Click to expand...

In an unbound text contrl:
=[Address] & chr(13) & chr(10) & [City] & ", " & [State] & " " & [Zip]

If you are using VBA, in addition to the above you can use either:
vbNewLine
or
vbCrLf
 
Top