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 / Mailmerge and Fax / October 2003

Tip: Looking for answers? Try searching our database.

Word 2k: Date formatting question #1

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Neil Marsh - 30 Oct 2003 18:55 GMT
Hi yet again...

I'm using the following to format my dates as they are pulled over from
Access into my Word merge file:

   { MERGEFIELD ANAirDate \@ "MMM. d, yy" }

which produces a date that looks like this:

   Mar. 1, 80

However, I'd like the date to look like this:

   Mar. 1, '80

Word help says I should just have to use this format to make it work:

   { MERGEFIELD ANAirDate \@ "MMM. d, 'yy" }

but Word barfs when I do that, giving me this error message:

   Error! Picture string contains unmatched quotes.

Any ideas on fixing this? Is there perhaps some global setting in Word
that I may have toggled on or off to make it function differently from
everyone else on the planet? :)

-/\/

---
Neil Marsh * Neil@AudioBoy.net
Cambridge, MA * http://AudioBoy.net

****************************************************************
"In the dream you are falling, lost in the listening distance as
dark locks in ... Nightfall!"

                     -- Opening narrative to "Nightfall"
                        CBC Radio horror anthology, 1980-1983
****************************************************************
Cindy M  -WordMVP- - 30 Oct 2003 20:49 GMT
Hi Neil,

Yeah, quotes and apostrophes are really tricky in Word fields. The only
way I was able to find (so far) is to use

{ Mergefield ANAirDATE \@ "MMM. d, { Quote “´” }yy" }

Where you'd need to press Alt+0180 to insert the accent-quote. I can't
find any way to do a plain '. I can get a curly-quote to work, as well,
but I think that would be much worse than the accent...

> However, I'd like the date to look like this:
>  
[quoted text clipped - 7 lines]
>  
>     Error! Picture string contains unmatched quotes.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

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.