 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2004losing properties when merging
Can anyone tell me how I can keep my fieldproperties when merging fields from a query in access to word ? Values with two decimals in the query have four decimals after beiing merged. Thank you Add a \# "#,###.00" formatting switch inside the closing } of the mailmerge field in the mailmerge main document. Use Alt+F9 to toggle on the field codes.  SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Can anyone tell me how I can keep my fieldproperties when > merging fields from a query in access to word ? Values > with two decimals in the query have four decimals after > beiing merged. > > Thank you Ok, this works, except now I 'lose' my zero. For example : 0,66 becomes ,66. Can you also help me with that ? thanx >-----Original Message----- >Add a \# "#,###.00" formatting switch inside the closing } of the mailmerge [quoted text clipped - 9 lines] > >. Change the switch to \# "#,##0.00" SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Ok, this works, except now I 'lose' my zero. For > example : 0,66 becomes ,66. Can you also help me with [quoted text clipped - 27 lines] >> >>. actually, the only way to keep two numbers behind the decimal is when I use the following switch : \# "#,##" Using your second recommendation increases the number of decimal places and doesn't restore the "0". Any more suggestions ? Thanx again >-----Original Message----- >Change the switch to [quoted text clipped - 34 lines] > >. Do you live in a country that uses a comma as a decimal separator? In which case, you need \# "0,00" Essentially you need to use 0 to force a 0 character for zero rather than # which shows empty for zero. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > actually, the only way to keep two numbers behind the > decimal is when I use the following switch : [quoted text clipped - 44 lines] >> >> .
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.