Peter Hibbs,
From G. Mayor site:
Formatting Word Fields:
http://www.gmayor.com/formatting_word_fields.htm
{ MERGEFIELD "BuildingInsured" \# "£,0.00;(£,0.00 ) }"
--
Add MS to your News Reader:
news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate
"Peter Hibbs" wrote in message
...
I am using Access 2003 and Word 2003.
I have a mail merge document linked to a table in an Access database.
Some Currency type fields in the database are displayed in the Word
doc but I am trying to get the format just right. Here is the switch
code I am using :-
{ MERGEFIELD "BuildingInsured" \# £#,##0.00 }
This is fine for a figure like £123,456.78 BUT for a figure of say 0
it displays as £ 0.00 instead of £0.00
The # characters seem to be showing as spaces. Is there any way to
tidy this up to show the currency symbol next to the highest digit?
Peter Hibbs.