Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / January 2006

Tip: Looking for answers? Try searching our database.

vbCrLf displays as ? in formfields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul Isaak - 17 Jan 2006 17:07 GMT
I'm trying to populate a series of formfields in a word doc with info
obtained programmatically from outlook.

my problem is that if the outlook field contains a linefeed character or a
carriage return (among others), the formfield in word displays it as ??
instead of inserting a Linefeed.

so  an address displays as...

       123  anystreet ?? Las Vegas, NV ?? USA

instead of

       123  anystreet
       Las Vegas, NV
       USA

here's the code in question

    contractdoc.documentscontractdocid).formfields"Customer_Address").result=Application.ActiveExplorer.Selection(1).BusinessAddress

All thoughts appreciated.

Paul

Signature

__________________________________

The Comedy & Juggling of Paul Isaak
http://www.funnyjuggler.com

Toll Free -  1-877-852-4590

Paul Isaak - 17 Jan 2006 17:33 GMT
> my problem is that if the outlook field contains a linefeed character or a
> carriage return (among others), the formfield in word displays it as ??
> instead of inserting a Linefeed.

when I posted this msg, outlook has changed the "square box" I typed into
"question marks".  replace the question marks above with unicode 25a1 to
understand my original question (which brings about another question - how
do I type a msg with unicode chr 25a1, without if changing in the news
server)
Doug Robbins - Word MVP - 18 Jan 2006 13:00 GMT
The Outlook Contacts folder contains the following fields in addition to the
Business_Address field

Business_Address_Street
Business_Address_City
Business_Address_State
Business_Address_Postal_Code
Business_Address_Country

You should get the data from the individual fields rather than from the
Business_Address field that arranges the individual fields

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm trying to populate a series of formfields in a word doc with info
> obtained programmatically from outlook.
[quoted text clipped - 20 lines]
>
> Paul
Cindy M  -WordMVP- - 19 Jan 2006 17:23 GMT
Hi Paul,

> I'm trying to populate a series of formfields in a word doc with info
> obtained programmatically from outlook.
>  
> my problem is that if the outlook field contains a linefeed character or a
> carriage return (among others), the formfield in word displays it as ??
> instead of inserting a Linefeed.

the form fields are in a Word table, I'm guessing? And there's no paragraph
mark (¶) preceding the end-of-cellmarker?

This is a known bug in Word. Press ENTER at the end of the cell and the
problem should go away. (If this makes the cell "too tall", set an exact row
height)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.