Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Access currency field
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Access currency field
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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Access currency field
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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Currency from Access Query | Mailmerge | |||
Access currency field wont format correctly in word mail merge | Mailmerge | |||
Currency fields in Access lose th currency format whn merged why | Mailmerge | |||
MailMerge with Access File - need to format currency | Mailmerge | |||
How do I reformat currency merged from Access query | Microsoft Word Help |