Symbols not merged from Access2003 to Word2003

[Ed McMinn]

When my users are doing a mail merge in Word2003 linked to
a query in Access2003 symbols such as $ and phone number
formatting (xxx)xxx-xxxx are not coming into the word
document. Any ideas appreciated.

 

[david epsom dot com dot au]

/Probably/ the symbols are not stored with the data:
you /probably/ just have numbers in the tables, and
the $ and formatting are just display formats.

There are three ways to handle this: (1) Change your
database to store strings instead of numbers (but
you won't be able to easily add your $ amounts any
more) or (2) Apply the display formatting again in
Word (but you will need to find someone who understands
Word well enough to do this) or (3) Change the query
so that it converts the numbers to strings and adds
whatever formatting is necessary.

(david)