access data (numbers) do not format correctly in merge to MS word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use a query to extract computed data. The data is formatted correctly in
Access. BUT when it merges into word, the formatting does not remain. I have
tried to format the merge code in word but this does not work either
 
I use a query to extract computed data. The data is formatted correctly in
Access. BUT when it merges into word, the formatting does not remain. I have
tried to format the merge code in word but this does not work either
Click to expand...

In the query grid:
TheDate:Format([DateField],"mmm d, yyyy")

Will format the today's date as "December 20, 2005"
Then use [TheDate] in the mail merge instead of [DateField].
 
If you set the Format Property of the relevant Columns (in the Query Grid),
Access will display as you want. However, if you use the Query as
DataSource for MailMerge, Access will only pass the actual values to Word,
not the formatted display to Word.

You can either use proper formatting String in your MailMerge Fields (in
Word MailMerge doc) or alternatively, use the Format() function in your
Query to convert the numeric values to String values and in this case,
Access will pass the String values (representing your numeric values in the
correct format) to Word and Word will use the String values verbatim.
 
Back
Top