Importing dates from Access 2007 to Word

D

David Hawkes

My date fields in Access 2007 are formatted to UK style (dd/mm/yyyy) but
always reverse to US style (mm/dd/yyyy) in a Word merge document.

Can this be corrected? Help would be welcome.
 
J

Joseph Meehan

I suggest you need to change the default date format in Word/Windows
and/or the specific fields in Word. The format does not follow the data.
The format is a display property and not part of the data that is exported
unless you are exporting it as text.
 
D

David Hawkes

Thanks for reply.

I have checked the settings in Windows & Word, & both are correct for the UK
style (dd/MM/yyyy). I have tried to find a way of editing the date format
entry in the merge field but so far without success. I have used 'edit field'
after right-clicking the merge field name, but in trying to chang the date
format I get today's date & not the imported data. Further guidance would be
much appreciated. Thanks.
 
B

Beth Melton

You can add a date-time format switch to your merge field and modify the
format. To do so:

- In Word, press Alt+F9 to toggle the field codes
- At the end of your date merge field, add the following (inside the field
braces): \@ "dd/MM/yyyy"

The field would look something like:
{MERGEFIELD <FieldName> \@ "dd/MM/yyyy"}

Note the capital "M" for Month and the space before and after \@

- Press Alt+F9 to toggle off the view of field codes.
- Right-click the date merge field and click Update Field to update the
formatted display.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
D

David Hawkes

Many thanks - it works!

I had missed the Alt/F9 bit to toogle the field codes. Great!
 
Top