Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007

    Unanswered: Date format changes when merging with Word

    Can anyone tell me why when I use data from my Access database as the merge data for a Word mail merge the date format changes from 24/10/2007 to 10/24/2007. (In Australia we show the day then the month then the year)
    Funnily enough this problem hasn't occured in previous years but now is.
    I've tried changing the Access field to 24 Oct 2007 but the Word file still picks up 10/24/2007. I've even tried exporting to Excel and pulling the data from there but same problem.

    I realise this may be the wrong forum to ask but thought I'd ask anyway.


  2. #2
    Join Date
    Mar 2007
    See if this suggestion resolves your issue.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  3. #3
    Join Date
    Jun 2007
    Maitland NSW,Australia


    I use the following coding when writing a date to a bookmark in a word document

    .Selection.Text = Format(Forms!frm_request!persondob, "dd-mmm-yyyy")

    The input data is in the format dd-mmm-yyyy e.g. 30-MAY-2007 it is displayed in the word document as 30-MAY-2007 using the above format.

  4. #4
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    it could be caused by a setting in your word or word document.
    I've seen this sort of problem when using say Letter paper, or if some software has updated the normal template.

    check the language dictionary and internationalisation settigns for either you template or document you are struggling with

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts