Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
dns2005
 
Posts: n/a
Default Insert Field - Database - Wrong Date Format

Please help!!

I've had an ongoing problem with inserting a database query into a word
document via the Insert Field option, in that the date format changes from UK
to US during the transfer from MS Access to Word. I'm using Office 2003 and
all SPs are up to date. I've checked the language settings and this is set to
UK default (both within Control Panel and also MS Office Language settings.
I had this problem previously when using Office XP and had hoped that
upgrading would resolve it, unfortunately this was not the case. The steps I
follow a

Within MS Word - Insert Menu, Field, Database, Insert Database, Get Data,
Select the relevant MS Access DB and then the Query, Insert All and check the
Insert Data as Field option, however, still I end up with a US date format.

Within the database itself the date shows as UK and the original table entry
is set to Date/Time, Short Date.

Any advice you could offer would be greatly appreciated.

Thanks again.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the date format to a long date after merging it Marisa Mailmerge 2 October 31st 05 03:15 PM
Mail Merge Field window should remain open to insert multiple fiel Steinway60 Mailmerge 1 July 20th 05 04:08 PM
Insert a file into a merge field kim Mailmerge 1 July 18th 05 05:13 PM
inserting a date field for a future date rm Microsoft Word Help 2 January 10th 05 07:18 PM
How do I insert and format part of a data field in a Word document Graham Blundell Microsoft Word Help 4 December 1st 04 02:51 PM


All times are GMT +1. The time now is 11:53 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"