problems with Word Merge

[Guest]

I have an Access table, with a query. I am using the query as a data source
in a word document. I have the table setup where a few fields are formatted
as currency, however, after the word merge, they are no longer currency, just
a number. For some reason, this document was working fine this morning. I
came back from lunch, made a change or two, and now it doesn't work. Any
ideas, I am totally stumped.

Thanks -

 

[Guest]

Nevermind, I just realized this should be a Word question. However, if
anyone can help, I would appreciate it. I have tried the whole alt F9 bit
and all, and now I just get some strange number, not what I have in Access.

 

[Joseph Meehan]

Nevermind, I just realized this should be a Word question. However,
if anyone can help, I would appreciate it. I have tried the whole
alt F9 bit and all, and now I just get some strange number, not what
I have in Access.

What format is the field in the table?

What format is the field in Word?

 

[Van T. Dinh]

In you MailMerge document, just format the appropriate MergeField as
Currency.

The reason is that data passed from Access to Word is simply numeric values
without format.

HTH
Van T. Dinh
MVP (Access)