Merging data to Check box fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keith Robertson - 19 Jan 2004 12:38 GMT

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

Reply to this Message

Graham Mayor - 19 Jan 2004 12:53 GMT

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}"}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hi,
>
[quoted text clipped - 8 lines]
>
> Keith

Reply to this Message

Cindy M -WordMVP- - 19 Jan 2004 19:03 GMT

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
[quoted text clipped - 7 lines]
> {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 :-)

Reply to this Message

Graham Mayor - 20 Jan 2004 07:57 GMT

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 :)

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

Cindy M -WordMVP- wrote:

> Hi Graham,
>
[quoted text clipped - 20 lines]
> This reply is posted in the Newsgroup; please post any follow
> question or reply in the newsgroup and not by e-mail :-)

Reply to this Message

Keith Robertson - 23 Jan 2004 12:31 GMT

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

>-----Original Message-----
>I knew that, but where there are differences in formatting sizes to the
[quoted text clipped - 28 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 23 Jan 2004 17:47 GMT

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

:-)

Reply to this Message

Keith Robertson - 27 Jan 2004 16:00 GMT

Yes that works too great Thanks.

>-----Original Message-----
>Hi Keith,
[quoted text clipped - 19 lines]
>
>.

Reply to this Message