Access currency field wont format correctly in word mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marnee - 01 Jun 2005 00:02 GMT

I have a currency field in an Access 2003 database which when merged as a
mergefield in word will not format properly. The £ sign is not imported,
neither is the decimal point or any decimal characters if the value is 0
(zero).

Help it was easy in Access 2000!!!

Reply to this Message

Graham Mayor - 01 Jun 2005 04:14 GMT

Word is now expected to provide the formatting - see
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have a currency field in an Access 2003 database which when merged
> as a mergefield in word will not format properly. The £ sign is not
> imported, neither is the decimal point or any decimal characters if
> the value is 0 (zero).
>
> Help it was easy in Access 2000!!!

Reply to this Message

Marnee - 01 Jun 2005 18:58 GMT

Many Thanks for your help

> Word is now expected to provide the formatting - see
> http://www.gmayor.com/formatting_word_fields.htm
[quoted text clipped - 5 lines]
> >
> > Help it was easy in Access 2000!!!

Reply to this Message

Graham Mayor - 02 Jun 2005 05:40 GMT

You are welcome :)

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Many Thanks for your help
>
[quoted text clipped - 15 lines]
>>>
>>> Help it was easy in Access 2000!!!

Reply to this Message