| 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 | |||
Linear Mode
