[Graham Mayor]

Did you update the field after adding the switch?
See http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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


jan34748 wrote:
I have had this same problem, merging from Excel, with the merge in
Word returning multiple digits after the decimal. I've tried
everything I can think of, including the MERGEFIELD Numeric \# 0.00
solution offered in a reply below, but nothing produces the desired 2
digits after the decimal. I know I must be missing something here.

" wrote:

Hello. When merging from Access 2003 to Word 2003, numbers have
extra digits. ie: 1.95 in Access shows as 1.94999999 in Word.
However, my situation is more complex than usual.

The data table in Access comes from SQL constructed in VB. The
problem fields may contain and should show many different precisions
(ie: 4000,
3.2, 0.99, 0.0001) or text (ie: "0.4" or "N/A"). Using { MERGEFIELD
Numeric \# 0.00 } always gives me two decimal places and, oddly,
converts text "0.4" to numeric 0.40. Is there a merge field switch
to simply merge whatever Access shows me?

Sure, use DDE... but how? My merge is done in VB using
Word.Document.MailMerge.OpenDataSource and .Execute, all from one
Access command button with no extra user intervention. Can I convert
..OpenDataSource to use DDE, and do so without any extra dialog
boxes?

Last resort - Can I convert all numbers to text in SQL before
building the data table? Thanks in advance for any help.