Date fields in Microsoft Access 2007 when mail merged into a letter etc, become American. ie 5/18/2010 instead of 18/5/10
Can anyone advise me how to correct this. I have tried changing the format in MS Access to medium (18-May-10) and it still doesnt come through correctly.
Software/Hardware used:
Microsoft Office Access 2007
Software/Hardware used:
Microsoft Office Access 2007
ASKED:
May 20, 2010 1:57 PM GMT
UPDATED:
May 21, 2010 4:32:38 PM GMT
RELATED QUESTIONS
- Data transfer from Access 2007 to Excel 2007 stops at 65,xxx rows
- Passive node is attempting to access Forefront data files, accessible only to active cluster nodes hosting the relevant physical disk resource.
- MSexhangeIS Eror 9667-Named Properties and Replica Identifier Quota
- Password in Delete Button in MS Access 2007
- Edit .accdb from multiple workstations
- Forms in Access 2007
- access supoort beyond 2007
- MS Project Server errors
- Foreign Intruder SMBCONNMONITORTP
- Migrating Access Tables in MYSQL Server using MYSQL Server Enterprise Manager
Answer Wiki:
Have you looked at the formatting in Word, as, if the formatting in Access is correct, then it can only be changed during the transfer into the mail merge fields.
I take it that you are using Word. Whatever word processing software you are using, I'd start there.
I take it that you are using Word. Whatever word processing software you are using, I'd start there.
4,625 pts.
To see other answers submitted to the Answer Wiki View Answer History.
