Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2007

Tip: Looking for answers? Try searching our database.

Radio Buttons and Word Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rodger - 25 Jan 2007 17:34 GMT
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
Peter Jamieson - 26 Jan 2007 12:33 GMT
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
> Hello all,
>
[quoted text clipped - 7 lines]
> TIA,
> Rodger
Rodger - 26 Jan 2007 15:37 GMT
OK sounds good I will give that a try otherwise they will just have to get
this report from Access . . . .

> 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,
[quoted text clipped - 66 lines]
> > TIA,
> > Rodger
 
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.