[Peter Hibbs[_2_]]

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.