code to start a new line in an expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top