| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how 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. |
|
#2
|
|||
|
|||
|
You need to use one or more IF fields.
-- Charles 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. "Righteous Brother" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
An if statement will not allow me to alter the checked status of a check box.
Unless you know how? Regards, Righteous One. "Charles Kenyon" wrote: You need to use one or more IF fields. -- Charles 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. "Righteous Brother" wrote in message ... 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. |
|
#4
|
|||
|
|||
|
IF statements will not allow me to change the checked property of a checkbox
during a mailmerge. Unless you know how? Regards, Righteous Brother. "Charles Kenyon" wrote: You need to use one or more IF fields. -- Charles 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. "Righteous Brother" wrote in message ... 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. |
|
#5
|
|||
|
|||
|
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. -- Charles 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. "Righteous Brother" wrote in message ... IF statements will not allow me to change the checked property of a checkbox during a mailmerge. Unless you know how? Regards, Righteous Brother. "Charles Kenyon" wrote: You need to use one or more IF fields. -- Charles 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. "Righteous Brother" wrote in message ... 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. |
|
#6
|
|||
|
|||
|
Wow, how? Could you extend on that by giving me an example?
Regards, Righteous One. "Charles Kenyon" wrote: 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. -- Charles 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. "Righteous Brother" wrote in message ... IF statements will not allow me to change the checked property of a checkbox during a mailmerge. Unless you know how? Regards, Righteous Brother. "Charles Kenyon" wrote: You need to use one or more IF fields. -- Charles 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. "Righteous Brother" wrote in message ... 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. |
|
#7
|
|||
|
|||
|
- = 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/downl...#CheckboxAddIn for an exploration of these. -- Charles 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. "Righteous Brother" wrote in message news  Wow, how? Could you extend on that by giving me an example? Regards, Righteous One. "Charles Kenyon" wrote: 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. -- Charles 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. "Righteous Brother" wrote in message ... IF statements will not allow me to change the checked property of a checkbox during a mailmerge. Unless you know how? Regards, Righteous Brother. "Charles Kenyon" wrote: You need to use one or more IF fields. -- Charles 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. "Righteous Brother" wrote in message ... 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. |
|
#8
|
|||
|
|||
|
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. "Charles Kenyon" wrote: - = 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/downl...#CheckboxAddIn for an exploration of these. -- Charles 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. "Righteous Brother" wrote in message news Wow, how? Could you extend on that by giving me an example? Regards, Righteous One. "Charles Kenyon" wrote: 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. -- Charles 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. "Righteous Brother" wrote in message ... IF statements will not allow me to change the checked property of a checkbox during a mailmerge. Unless you know how? Regards, Righteous Brother. "Charles Kenyon" wrote: You need to use one or more IF fields. -- Charles 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. "Righteous Brother" wrote in message ... 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. |
|
#9
|
|||
|
|||
|
- = 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 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get all my Word documents within one Word window | Microsoft Word Help | |||
| Losing check boxes form fields when saving as a web page. | Microsoft Word Help | |||
| excel/word merge: why are some data fields partially truncated? | Mailmerge | |||
| Spell check fields in templates? | Microsoft Word Help | |||
| posting data from text input fields to fields later in document | Microsoft Word Help | |||
Linear Mode
