View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M -WordMVP-
 
Posts: n/a
Default Insert Field - Database - Wrong Date Format

Hi ?B?ZG5zMjAwNQ==?=,

Thanks for your advice, I've tried changing the connection methods and still
encounter the same error. I daresay I'll have to live with formatting the
field as Text within the database.

Set up a query (rather than using a table). In the query, instead of using the
data field directly, create an expression:

xDate: Format({datefield}, "m/d/yy")

this will pass the information as literal text and Word won't try to "fiddle"
how it displays. "xDate" can be anything you like, it's what will appear as the
field name in the resultant dynaset. Put the field name in the braces.

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 :-)