 |
 | 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 / June 2004Null values
I have an access table with some numeric values in it. Some of them have the value Nul When I do a mail merge with word XP sp3 null values are translated to 0, I don't have the problem with other word versions (98, 2000 ... Jean Pau If you check the "Confirm conversion at Open" box under Tools>Options>General and try a different connection method, you may be able to restore the previous behaviour, or, if you toggle on the field codes and add the following formatting switch inside the closing }, the 0's will not be displayed \# "#;(#);" modify the formatting inside the "" to get what you want For exampe \# "#.00;(#.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 > I have an access table with some numeric values in it. Some of them have the value Null > > When I do a mail merge with word XP sp3 null values are translated to 0, I don't have the problem with other word versions (98, 2000 ...) > > Jean Paul Using the formatting method you explained gives no solution because the value 0 exists also. I tried already the second solution, it give me no result. Especially the word file is called from within Access and I don't want the user to chose his connectio J In that case, you will probably have to use and If ... Then ... Else field construction in the mailmerge main document and maybe also you might need to crate a Null to something function in Access and use that in a query to set the null values to some unlikely number (I assume that it is a numeric field). However, thinking about it now, if you use the Format ()function in an Access query, that will cause the data to be considered as text and it may then merge how you want it to. 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 > Using the formatting method you explained gives no solution because the value 0 exists also. I tried already the second solution, it give me no result. Especially the word file is called from within Access and I don't want the user to chose his connection > JP |
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.