View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Access currency field

You are welcome

--

Graham Mayor - Word MVP

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



Tom wrote:
Hi Graham

Many thanks that works brilliantly.

Tom
"Graham Mayor" wrote in message
...
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

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



Tom wrote:
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