Formatting Issue on Number Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brig - 25 Jan 2005 15:45 GMT

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.

Reply to this Message

Peter Jamieson - 25 Jan 2005 21:40 GMT

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

{ MERGEFIELD mynumber }

try

{ MERGEFIELD mynumber \##.00 }

Peter Jamieson

> Using Office XP, we have a database from Access & the mail merge document
> on Word.
[quoted text clipped - 10 lines]
>
> Thank you.

Reply to this Message

Brig - 26 Jan 2005 14:18 GMT

I'll give it a shot.

Thank you very much.

Brig

> Try using a numeric switch in your Word merge field, e.g. instead of
>
[quoted text clipped - 20 lines]
>>
>> Thank you.

Reply to this Message