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 / October 2003

Tip: Looking for answers? Try searching our database.

MergeField with If statement to populate Checkbox

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Felicia - 03 Oct 2003 16:32 GMT
I would like to use a mergefield to populate a checkbox.  
If the mergefield City=1 then I want the checkbox to be
checked, if not, do not check it.  Is there a way to do
this?
Dan - 03 Oct 2003 20:40 GMT
Yes.
Basically, create your checkbox, than right-click the
checkbox and choose format control...
Under the Control tab where it says "Cell Link" type in
the cell reference(make it absolute if necessary) or click
on the cell that you want, then click OK.  As soon as you
do this the cell that it is linked to will say false.  If
you type the number 1 over that word False or any other
number besides zero in that cell it will check the box.  0
will uncheck it.  I'm not sure if that answers your
question about your mergefield, but it should give you an
idea on where to go from here.

>-----Original Message-----
>I would like to use a mergefield to populate a checkbox.  
>If the mergefield City=1 then I want the checkbox to be
>checked, if not, do not check it.  Is there a way to do
>this?
>.
Dan - 03 Oct 2003 20:54 GMT
Nevermind...  I just finished doing something similar in
Excel and that was evidently on my head.  I gave you the
answer for how to do it in Excel.  Sorry...  I'm not sure
how you would do it in Word... that's why I do mine in
Excel.

>-----Original Message-----
>I would like to use a mergefield to populate a checkbox.  
>If the mergefield City=1 then I want the checkbox to be
>checked, if not, do not check it.  Is there a way to do
>this?
>.
Cindy Meister  -WordMVP- - 04 Oct 2003 16:04 GMT
Hi Felicia,

> I would like to use a mergefield to populate a checkbox.  
> If the mergefield City=1 then I want the checkbox to be
> checked, if not, do not check it.  Is there a way to do
> this?

Somewhat indirect, but yes, you can do this :-)

Use an IF field to check the value, and have it display an
appropriate symbol (from Insert/Symbol).

Set this up:
- Insert Word Field on the mail merge toolbar
- Set up the comparison for the merge field, and type
placeholder text in the "True" and "False" boxes
- Back in the merge doc, Alt+F9 to display the field codes
- Double-click on the "True" placeholder, then choose the
symbol you want from Insert/Symbol
- Do the same for the "False" placeholder
- Alt+F9 again to hide the field codes

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
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.