line break in concatenated text

[SMC, the Amateur]

I want to insert a line break between CompanyName and ContactFirstName so that

=nz([CompanyName]&[ContactFirstName]& " "& [ContactLastName])

displays as:

CompanyName
ContactFirstName ContactLastName

 

[Al Campagna]

= [CompanyName] & vbCrLf & [ContactFirstName] & " " & [ContactLastName]

 

[fredg]

I want to insert a line break between CompanyName and ContactFirstName so that

=nz([CompanyName]&[ContactFirstName]& " "& [ContactLastName])

displays as:

CompanyName
ContactFirstName ContactLastName

As the control source of an unbound text control:

=[CompanyName] & chr(13) & chr(10) & [ContactFirstName] & " " &
[ContactLastName]

The chr(13) & chr(10) must be in that order.

In VBA you can use vbNewLine or vbCrLf.

 

[SMC, the Amateur]

Thank You! Thank You!

Al, when I entered yours it invaribly made added brackets making it a field
or whatever

fredg, it worked!

problem solved ~ wish I'd tried this group 4 years ago!

 

[Al Campagna]

SMC,
As a calculated control, use chr(13) & chr(10) to cause the line feed
From module code, vbCrLf would work.
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Thank You! Thank You!

Al, when I entered yours it invaribly made added brackets making it a field
or whatever

fredg, it worked!

problem solved ~ wish I'd tried this group 4 years ago!

I want to insert a line break between CompanyName and ContactFirstName so that

=nz([CompanyName]&[ContactFirstName]& " "& [ContactLastName])

displays as:

CompanyName
ContactFirstName ContactLastName