C
Christine
We have a Database which we have recently converted from
Access 97 to Access XP. Since then when merging it with
Word the dates have been giving us a problem.
In Access the dates all display correctly as Medium Date
(08-April-2004) but in the Word document after merging the
date can appear with what should be the day displaying as
the month and the month displaying as the day which makes
a total nonsense of the dates inserted in Access. I have
checked all the settings ie Regional & Language Options,
but on this one computer the date will insist on
displaying back to front.
On my computer it displays incorrectly unless I add
\@"ddMMMMyyyy into the Word merge document when it
displays correctly. Adding this to the other computer
makes no difference!
Any help would be much appreciated. Ta.
Christine Ward
Access 97 to Access XP. Since then when merging it with
Word the dates have been giving us a problem.
In Access the dates all display correctly as Medium Date
(08-April-2004) but in the Word document after merging the
date can appear with what should be the day displaying as
the month and the month displaying as the day which makes
a total nonsense of the dates inserted in Access. I have
checked all the settings ie Regional & Language Options,
but on this one computer the date will insist on
displaying back to front.
On my computer it displays incorrectly unless I add
\@"ddMMMMyyyy into the Word merge document when it
displays correctly. Adding this to the other computer
makes no difference!
Any help would be much appreciated. Ta.
Christine Ward