[[email protected]]

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.