 |
 | 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 / May 2005how do i check a checkbox based on a fields data
Hi. I have had this issue for quite some time and gave up on it actually being possible in Word, so I hope someone can prove me wrong. I have a word master document (assessmentform_master.doc). It is an assessment form which was designed by our sponsors, and so cannot be changed. In this document are 5 checkbox merge fields (ckMeasPP, ckMeasTH, ckMeasLA, ckMeasNT and ckMeasRF). The datasource is in Excel and has entries for these 5 fields, MeasPP, MeasTH etc. Each of these fields contain either X or an empty cell. When I merge the document with its datasource I want the checkboxes for each record to be checked (If X) or unchecked (If empty cell). I don't even know where to start. Hope someone does. Regards, Nick. You need to use one or more IF fields.  SignatureCharles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. > Hi. I have had this issue for quite some time and gave up on it actually > being possible in Word, so I hope someone can prove me wrong. [quoted text clipped - 18 lines] > Regards, > Nick. An if statement will not allow me to alter the checked status of a check box. Unless you know how? Regards, Righteous One. > You need to use one or more IF fields. > > Hi. I have had this issue for quite some time and gave up on it actually [quoted text clipped - 19 lines] > > Regards, > > Nick. IF statements will not allow me to change the checked property of a checkbox during a mailmerge. Unless you know how? Regards, Righteous Brother. > You need to use one or more IF fields. > > Hi. I have had this issue for quite some time and gave up on it actually [quoted text clipped - 19 lines] > > Regards, > > Nick. No, they won't. However, they let you display a checked box if the condition is met, and a (separate) unchecked box if it is not met. SignatureCharles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. > IF statements will not allow me to change the checked property of a > checkbox [quoted text clipped - 27 lines] >> > Regards, >> > Nick. Wow, how? Could you extend on that by giving me an example? Regards, Righteous One. > No, they won't. However, they let you display a checked box if the condition > is met, and a (separate) unchecked box if it is not met. [quoted text clipped - 29 lines] > >> > Regards, > >> > Nick. - = unchecked checkbox x = checked checkbox { IF {REF "MyValue"} = "Correct" "x" "-" } Haven't tried it with checkboxes from the Forms toolbar, but if that does't work you could use boxes from the Symbols set. There are a number of ways to create and use clickable checkboxes in documents / templates. Some require protected or locked forms, others do not. Take a look at the Checkbox template available at http://www.addbalance.com/word/download.htm#CheckboxAddIn for an exploration of these. SignatureCharles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. > Wow, how? Could you extend on that by giving me an example? > [quoted text clipped - 37 lines] >> >> > Regards, >> >> > Nick. Hi Charles. Thanks for your help - just managed to find the answer on MS website. Just in case anybody is skin=mming around here on the same problem, heres the link. Cheers, Thats saved me a couple of weeks work and made everybody very happy. I am not surprized that I didn't work it out myself though because its a workaround that would have taken me forever to see. Heres the link: http://support.microsoft.com/?kbid=211300 Cheers, Nick. > - = unchecked checkbox > x = checked checkbox [quoted text clipped - 49 lines] > >> >> > Regards, > >> >> > Nick. - = unchecked checkbox x = checked checkbox { IF {REF "MyValue"} = "Correct" "x" "-" } Haven't tried it with checkboxes from the Forms toolbar, but if that does't work you could use boxes from the Symbols set. There are a number of ways to create and use clickable checkboxes in documents / templates. Some require protected or locked forms, others do not. |
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.