Currency fields in Access lose th currency format whn merged why

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PMasters - 01 Jun 2005 16:14 GMT

Can anyone help cure this formatting problem? Fields in Access selected as
currency fields merge without commas and dollar sign ending up in the merged
document.

Thanks

Reply to this Message

Peter Jamieson - 01 Jun 2005 20:13 GMT

Word is now expected to provide the formatting for numeric and date fields.

e.g. if you use Alt-F9 to display the field codes and have a field such as

{ MERGEFIELD mynumber }

you can type a "numeric formatting switch" to add formatting info, e.g.

{ MERGEFIELD mynumber \#"$,#.00" }

These formatting switches are documented in Word Help.

Peter Jamieson

> Can anyone help cure this formatting problem? Fields in Access selected
> as
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message