Using Office XP, we have a database from Access & the mail merge document on
Word.

In Access there is a field in number format with 2 decimal points.

However, when the field gets merged in word, we lost the formatting and
sword sometimes put only 1 decimal point or no decimal point at all if its a
whole number.

Is there a way to format the field in Word to show 2 decimal points?

Please note that we are not formating the number to show as currency.

Thank you.

Try using a numeric switch in your Word merge field, e.g. instead of

{ MERGEFIELD mynumber }

try

{ MERGEFIELD mynumber \##.00 }

Peter Jamieson

"Brig" wrote in message
...
Using Office XP, we have a database from Access & the mail merge document
on Word.

In Access there is a field in number format with 2 decimal points.

However, when the field gets merged in word, we lost the formatting and
sword sometimes put only 1 decimal point or no decimal point at all if its
a whole number.

Is there a way to format the field in Word to show 2 decimal points?

Please note that we are not formating the number to show as currency.

Thank you.

I'll give it a shot.

Thank you very much.

Brig


"Peter Jamieson" wrote in message
...
Try using a numeric switch in your Word merge field, e.g. instead of

{ MERGEFIELD mynumber }

try

{ MERGEFIELD mynumber \##.00 }

Peter Jamieson

"Brig" wrote in message
...
Using Office XP, we have a database from Access & the mail merge document
on Word.

In Access there is a field in number format with 2 decimal points.

However, when the field gets merged in word, we lost the formatting and
sword sometimes put only 1 decimal point or no decimal point at all if
its a whole number.

Is there a way to format the field in Word to show 2 decimal points?

Please note that we are not formating the number to show as currency.

Thank you.