mail merge currency

[Guest]

I linked an access document to a word document. one field format currency
with dollar sign, comma, and decimal places ($2,500.00) appears like number
(2500) how do i format it? how do i get it to work?

 

[Allen Browne]

You may be able to format the field in word by right-clicking it and adding
some codes to the field.

Alternatively, you could use a query as the source for the merge.
In the Field row of the query, enter:
Format[Field1], "Currency")
and it will output formatted text instead of a number.

 

[Guest]

if you're telling me to use the script in the 'field' on the Access database
query it won't accept the code as you suggested... I have found the same
problem except it is with standard numbers with commas. Despite having the
field formatted correctly for the database (in all instances of the number)
it doesn't format right in Word.

You may be able to format the field in word by right-clicking it and adding
some codes to the field.

Alternatively, you could use a query as the source for the merge.
In the Field row of the query, enter:
Format[Field1], "Currency")
and it will output formatted text instead of a number.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I linked an access document to a word document. one field format currency
with dollar sign, comma, and decimal places ($2,500.00) appears like
number
(2500) how do i format it? how do i get it to work?

 

[Allen Browne]

No. I am suggesting that you create a query in Access, and then use the
query for the mail merge to Word.

Assuming your field is named Amount:

1. Create a new query that uses your table.

2. In the Field row of the query design grid, enter:
cAmount: Format([Amount], "Currency")

3. Drag the other fields you want into the query grid.

4. Save the query.

When you use the cAmount field in Word, it will show the currency correctly.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message

if you're telling me to use the script in the 'field' on the Access
database
query it won't accept the code as you suggested... I have found the same
problem except it is with standard numbers with commas. Despite having
the
field formatted correctly for the database (in all instances of the
number)
it doesn't format right in Word.

You may be able to format the field in word by right-clicking it and
adding
some codes to the field.

Alternatively, you could use a query as the source for the merge.
In the Field row of the query, enter:
Format[Field1], "Currency")
and it will output formatted text instead of a number.

I linked an access document to a word document. one field format
currency
with dollar sign, comma, and decimal places ($2,500.00) appears like
number
(2500) how do i format it? how do i get it to work?