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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cgmorgan@ucsd - 20 Dec 2005 21:51 GMT

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

Reply to this Message

fredg - 20 Dec 2005 22:40 GMT

> 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

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].

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Van T. Dinh - 20 Dec 2005 22:40 GMT

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.

Signature

HTH
Van T. Dinh
MVP (Access)

>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

Reply to this Message