Access currency field

[Tom]

Hi

I am having an issue with an Currency field in an Access2003 table when
using that table as a data source for mailmerging into Word 2003.

From Accesss the field reads, correctly, as £500.00, when merged into Word
it reads 500.

What needs to be done so that it reads as £500.00 in the Word document.

TIA

Tom

 

[Graham Mayor]

You need to add a formatting switch eg {Mergefield CurrencyFieldName \#
"£,0.00"}
see http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Tom]

Hi Graham

Many thanks that works brilliantly.

Tom

 

[Graham Mayor]

You are welcome

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>