Combining fields and new line

[BartH_NL]

I want to make a new field in my Oulook Contact form which holds the full
person's name and address. I have found how I can combine the fields, but
can't find how to display them each on a new line.

I've got:

[Company] [Full name] [Address]

and it should display as:

[Company]
[Full name]
[Address]

In Word I would use ^p and in VBA it would be vbCr or vbCrLf.

What do I use here?

 

[Sue Mosher [MVP-Outlook]]

Use a formula field, not a combination field, and a formula like this:

[Company] & Chr(13) & Chr(10) & [Full Name] & Chr(13) & Chr(10) & [Business Address]

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[BartH_NL]

Sue, you are priceless! Have a hughe bunch of flowers.

Use a formula field, not a combination field, and a formula like this:

[Company] & Chr(13) & Chr(10) & [Full Name] & Chr(13) & Chr(10) & [Business Address]

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

I want to make a new field in my Oulook Contact form which holds the full
person's name and address. I have found how I can combine the fields, but
can't find how to display them each on a new line.

I've got:

[Company] [Full name] [Address]

and it should display as:

[Company]
[Full name]
[Address]

In Word I would use ^p and in VBA it would be vbCr or vbCrLf.

What do I use here?