Merging Access into Word - characters changed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LindaM - 09 May 2005 11:03 GMT

Word version: 2000
Access Version: 2000

We produce a monthly report in Word, using data from an Access dbase, usually
with no problems. Since last month we have changed Pounds to Euros in the
dbase, but Word continues to insert £ instead of €. We can find no trace of £
anywhere in the dbase or in the Word macros we use for formatting Any idea
what's happening and how to stop it?

Signature

Linda M

Reply to this Message

Graham Mayor - 09 May 2005 12:24 GMT

If we can assume that it is only the sign that is wrong, use a switch on the
merge field - http://www.gmayor.com/formatting_word_fields.htm
My guess is that you already have a £ sign in an existing switch.

Signature

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

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

> Word version: 2000
> Access Version: 2000
[quoted text clipped - 4 lines]
> can find no trace of £ anywhere in the dbase or in the Word macros we
> use for formatting Any idea what's happening and how to stop it?

Reply to this Message

LindaM - 09 May 2005 15:57 GMT

Hi Graham,

Thank you very much - you're right

Signature

Linda M

> If we can assume that it is only the sign that is wrong, use a switch on the
> merge field - http://www.gmayor.com/formatting_word_fields.htm
[quoted text clipped - 8 lines]
> > can find no trace of £ anywhere in the dbase or in the Word macros we
> > use for formatting Any idea what's happening and how to stop it?

Reply to this Message