How do I perserve currency format from Access 2003 qyerry into a .

[Guest]

I am trying to merge data from Access 2003 into a Word 2003 document and
preserve the currency formating (or for that fact any and all formating)

 

[Van T. Dinh]

IIRC correctly, there are 2 ways:

1. Use a Calculated Field in your Query which "converts" your numeric value
to formatted currency text using the Format(). For example, instead of
passing your CurrField raw to Word, you can create a Calculated Field /
Column like:

FormattedCurr: Format([CurrField], "Currency")

(You can also use the function FormatCurrency(), IIRC.)

When you use Word for merging, use the Calculated Field rather than the raw
Field.

Check Access VB Help on the 2 functions above.

2. You can use the raw Field but you will have to set the formats for the
MergeFields in Word. You will need to check Word Help on this.

HTH
Van T. Dinh
MVP (Access)