|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 17th, 2008, 01:44 PM
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
May 17th, 2008, 02:30 PM
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
May 17th, 2008, 03:39 PM
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
May 18th, 2008, 06:54 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
