Mail Merge Switch Format for Currency
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.
|