[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.

[Rich/rerat]

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.

[Peter Hibbs[_2_]]

Rich,

Thanks very much, that works perfectly (once I moved the last quotes
inside the brackets). The Web site has been bookmarked for future
reference.

Thanks again.

Peter Hibbs.

On Fri, 19 Feb 2010 14:41:54 -0500, "Rich/rerat"
wrote:

Peter Hibbs,

From G. Mayor site:
Formatting Word Fields:

http://www.gmayor.com/formatting_word_fields.htm

{ MERGEFIELD "BuildingInsured" \# "£,0.00;(£,0.00 ) }"