Merging data to Check box fields

[Keith Robertson]

Hi,

I am trying to merge binary (True / False) data into a
word doc and have it appear as a check box. It is
formatted in the query I am using as such, but appears in
Word as True or False.

Is there any way to get around this problem.

Much obliged for any help.

Keith

 

[Graham Mayor]

Should be easy enough. Enter the checked box character you require in your
document eg from the Wingdings 2 font and format it at the size you require
it to be in your merge document. Display the formatting characters (CTRL+*)
and select the character BUT NOT the paragraph mark. Save as an autotext
entry - Checkit. Do the same for the unchecked character and call that
Uncheckit.

Then in your merge document use a conditional field

{IF {Mergefield Fieldname} = "True" "{Autotext Checkit}" "{Autotext
Uncheckit}"}


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Cindy M -WordMVP-]

Hi Graham,

Actually, it doesn't even need to be part of an AutoText entry. The symbol
can be inserted directly into the IF field.

Should be easy enough. Enter the checked box character you require in your
document eg from the Wingdings 2 font and format it at the size you require
it to be in your merge document. Display the formatting characters (CTRL+*)
and select the character BUT NOT the paragraph mark. Save as an autotext
entry - Checkit. Do the same for the unchecked character and call that
Uncheckit.

Then in your merge document use a conditional field

{IF {Mergefield Fieldname} = "True" "{Autotext Checkit}" "{Autotext
Uncheckit}"}

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

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Graham Mayor]

I knew that, but where there are differences in formatting sizes to the
underlying text, autotext is perhaps an easier concept to convey in a plain
text message - and of course the technique has much wider application than
simply a checkbox character

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Keith Robertson]

Thanks to you both, I finally got it to work. The Curly
braces (Cntl+F9) were confusing.
A quick follow up, when merging a large number of
documents sometimes the check boxes do not update so you
get blank space instead of a checked or unchecked box. If
you right click the space and click Update Field it puts
the appropriate symbol in.
Any thoughts on that problem.

Thanks Keith

 

[Cindy M -WordMVP-]

Hi Keith,

A quick follow up, when merging a large number of
documents sometimes the check boxes do not update so you
get blank space instead of a checked or unchecked box. If
you right click the space and click Update Field it puts
the appropriate symbol in.
Any thoughts on that problem.

Does Ctrl+A, F9 in the merged result doc also work?

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

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Keith Robertson]

Yes that works too great Thanks.

-----Original Message-----
Hi Keith,

Does Ctrl+A, F9 in the merged result doc also work?

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

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e- mail


.