Headaches with Word Mail Merge

[Guest]

Hi,

I have created some VBA code in my Access (v2003) db to create a single
record mail merge using a Word document - works a treat.

Apart from 2 things. The formatting doesn't quite display properly in my
Word document.

For example, dates. Where I require date values from my Access DB record,
Word displays them using mm/dd/yy format - I require this to be displayed
using dd/mm/yy format as in the DB.

I have a similar problem with currency values - Word ommits the last 0 value
- if there is one. So, £1234.50 (as it appears in my DB) is displayed as
£1234.5 in my Word document. £1234.51 displays fine - must be something to
do with that last 0

Any one any ideas?? This is driving me insane as I am so, so, so close to
finishing my app!!!

 

[Guest]

All done - it was field switches in Word that was the solution to the problem.