View Single Post
  #2  
Old October 10th 06, 01:22 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Combining fields and new line

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"BartH_NL" wrote in message ...
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?

Ads