Home |
Search |
Today's Posts |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Numeric extra digits, with a complex twist
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mergefield formatting codes seem to combine digits in numeric data | Mailmerge | |||
numeric pictu formating merge field without rounding decimal digits? | Mailmerge | |||
Extra digits in merge from Excel (Office 2003) | Mailmerge |