Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Radio Buttons and Word Mail Merge
Hello all,
I have a form in Access that has around 60 Yes No radio button questions. I would like to merge the data with a Word Document but I cannot figure out how to get the radio buttons on a Word Document. Any ideas? TIA, Rodger |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Radio Buttons and Word Mail Merge
if you just need to print thngs that look like "pressed" or "unpressed"
buttons depending on the value of a YesNo field (or another type of field, try the following: Let's suppose your field is called "q1" and you have already created a mailmerge main document and connected it to your data source. Let's suppose for the moment that you have used a YesNo field to store it. Insert the following nested fields in your document. Each pair of {} needs to be the special field code braces that you can insert using ctrl-F9 - you can't just type them. { IF "{ MERGEFIELD q1 }" = "False" "unpressed button character" "pressed button character" } This assumes that you are using Word 2002/2003/2007 and have not altered the way it connects to Access. if you are using DDE (the default in Word 97/2000) or ODBC, then you need { IF "{ MERGEFIELD q1 }" = "0" "unpressed button character" "pressed button character" } Or if for example you are just using a text field with Y and N for "True" and "False", use { IF "{ MERGEFIELD q1 }" = "N" "unpressed button character" "pressed button character" } At this point, when you preview the merge, you should be seeing the text unpressed button character or pressed button character depending on the value in q1. Now use Alt-F9 to display the field codes again, and either a. locate suitable characters in Insert Symbol (for example Wingdings 161 and 164, Wingdings2 154 and 158, etc.) and insert them instead of the texts unpressed button character and pressed button character or b. insert suitable images instead Make sure the characters are displaying at the size you need, then copy/paste your nested mergefields and change the field name q1 to q2 for the next button, and so on. Peter Jamieson Then select insert the "q1" field (there are different ways to do this depending on the version of Word and so on, but if you can't work it out, a. press ctrl-F9 to create a pair of the special "field code braces" {} (you can't just type them) b. type MERGEFIELD "q1" between the braces to give you { MERGEFIELD "q1" } Select the field and press F9 to update it, then Alt-F9 to display the result. Make sure you're seeing a preview result, not q1. Notice what "Rodger" wrote in message ... Hello all, I have a form in Access that has around 60 Yes No radio button questions. I would like to merge the data with a Word Document but I cannot figure out how to get the radio buttons on a Word Document. Any ideas? TIA, Rodger |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Radio Buttons and Word Mail Merge
OK sounds good I will give that a try otherwise they will just have to get
this report from Access . . . . "Peter Jamieson" wrote in message ... if you just need to print thngs that look like "pressed" or "unpressed" buttons depending on the value of a YesNo field (or another type of field, try the following: Let's suppose your field is called "q1" and you have already created a mailmerge main document and connected it to your data source. Let's suppose for the moment that you have used a YesNo field to store it. Insert the following nested fields in your document. Each pair of {} needs to be the special field code braces that you can insert using ctrl-F9 - you can't just type them. { IF "{ MERGEFIELD q1 }" = "False" "unpressed button character" "pressed button character" } This assumes that you are using Word 2002/2003/2007 and have not altered the way it connects to Access. if you are using DDE (the default in Word 97/2000) or ODBC, then you need { IF "{ MERGEFIELD q1 }" = "0" "unpressed button character" "pressed button character" } Or if for example you are just using a text field with Y and N for "True" and "False", use { IF "{ MERGEFIELD q1 }" = "N" "unpressed button character" "pressed button character" } At this point, when you preview the merge, you should be seeing the text unpressed button character or pressed button character depending on the value in q1. Now use Alt-F9 to display the field codes again, and either a. locate suitable characters in Insert Symbol (for example Wingdings 161 and 164, Wingdings2 154 and 158, etc.) and insert them instead of the texts unpressed button character and pressed button character or b. insert suitable images instead Make sure the characters are displaying at the size you need, then copy/paste your nested mergefields and change the field name q1 to q2 for the next button, and so on. Peter Jamieson Then select insert the "q1" field (there are different ways to do this depending on the version of Word and so on, but if you can't work it out, a. press ctrl-F9 to create a pair of the special "field code braces" {} (you can't just type them) b. type MERGEFIELD "q1" between the braces to give you { MERGEFIELD "q1" } Select the field and press F9 to update it, then Alt-F9 to display the result. Make sure you're seeing a preview result, not q1. Notice what "Rodger" wrote in message ... Hello all, I have a form in Access that has around 60 Yes No radio button questions. I would like to merge the data with a Word Document but I cannot figure out how to get the radio buttons on a Word Document. Any ideas? TIA, Rodger |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how smart can a word 2003 mail merge letter be? | Mailmerge | |||
Email merge using word 2000 | Mailmerge | |||
Can I add outlook voting buttons to an email from Word Mail Merge | Mailmerge | |||
Inactive Word document window after completing Mail Merge 2003 | Mailmerge | |||
How do I create a Mail Merge with Voting Buttons using Word and O. | Mailmerge |