newline?

[sdkramer]

How to I do a new line in a string. I'm trying to make an address line in a text box so it reads like this

[fname] & space(1) & [lname] & "\n" & [address1] & "\n" & iif(isnull([address2]),[City]&", "& [State] & space(2) & [Zip],[address2]&"\n"&[City]&", "& [State] & space(2) & [Zip])

If i was sure there was always going to be an address2 I wouldn't even need this I'd just use seperate text boxes, but I need it to flow continuously

TIA,

Seth

 

[sdkramer]

NOTE: "\n" does not work. What do I use instead?

 

[Rich]

=[Company Name] & Chr(13) & Chr(10) & [Address] & Chr(13) & Chr(10) & [City] etc

 

[sdkramer]

awesome thanks sorry if this was an extraordinarily dumb question. danke

 

[ghudson]

Check the help files for the Miscellaneous Constants for more options like the vbNewLine option.

=[Company Name] & vbNewLine & [Address] & vbNewLine & [City] etc