Mail Merge to MS Word Date and Currency not working

[trident]

I created a Data Collection form that will be merged in MS Word.



2 problems encountered is when merge in MS Word, the following are showing:

	ms access (Form)	ms word
Currency	2,000.00	2000
Date	19-June-2017	6/19/2017

How can I make the data appear in MS Word just the same as in MS Access.

I have updated the table in MS Access save the same as what I need but still the same result when merging in ms word.

Thank you for the assistance.

Trident

[Homegrownandy]

create a query that will format the results and use the query as the record source for the mail merge. (not sure if it will default back to the format issues you currently have but its worth a try)

[HiTechCoach]

I created a Data Collection form that will be merged in MS Word.

2 problems encountered is when merge in MS Word, the following are showing:

	ms access (Form)	ms word
Currency	2,000.00	2000
Date	19-June-2017	6/19/2017

How can I make the data appear in MS Word just the same as in MS Access.

I have updated the table in MS Access save the same as what I need but still the same result when merging in ms word.

Thank you for the assistance.

Trident

Trident,

Word sees the data from an Access table the way it is acutually stored. Only Acess can use the dsiplayformat properties.

In Word it is possibel to add formatting to Merge fields that match the display formatting in Access..


Date example:

{MERGEFIELD Date @ “d-MMM-yyyy”}

Currency Example:

{MERGEFIELD MoneyAmount # “$,0.00;($,0.00)”}

See: Office Watch: Formatting Mail Merge fields

[TommyK]

{MERGEFIELD MoneyAmount # “$,0.00;($,0.00)”} Does Not Work. The Access source data is formatted as currency in Access.
e.g.
$287.30 in Access, displays in the merged MSWord 2016, as
287.3
While I can hard code a $, getting the cent's place zero proves elusive

[TommyK]

HiTechCoach's link leads me to: "...Word 2003 and later versions use OLEDB to connect to the data source when performing a mail merge. Earlier versions used DDE connections. When you use DDE to convert the Microsoft Access or Microsoft Excel data instead of ODBC, the data is “masked” to display the correct format.
To change this setting, in Word – On the Tools menu, click Options, and the General tab. Click on the Confirm conversion at Open check box and click OK." Where is the Tools menu? This version of MSWord 2016 has moved the Tools menu from whence last I used it. HELP!

[Gicu]

You need to use switches in Word, have a look :
https://www.getfaxing.com/2016/08/29...sing-switches/
https://knowledgecenter.zuora.com/Bi..._Number_Fields

For currency try {MERGEFIELD MoneyAmount \# $#,#0.0}
Cheers,