When merging currency fields formatted as such in an Access query to a Word
mail merge document the field is displayed with out the currency sign and
from 0 to 8 decimal places.

How can I correct this please, I can find nothing on the help screens.

Use a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Richard Berrill wrote:
When merging currency fields formatted as such in an Access query to
a Word mail merge document the field is displayed with out the
currency sign and from 0 to 8 decimal places.

How can I correct this please, I can find nothing on the help screens.

Sounds like a mistake in the query. Post the actual SQL statement.


"Richard Berrill" Richard wrote in
message ...
When merging currency fields formatted as such in an Access query to a
Word
mail merge document the field is displayed with out the currency sign and
from 0 to 8 decimal places.

How can I correct this please, I can find nothing on the help screens.