Yes/No Fields in Mail Merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Iggies - 18 Apr 2006 00:41 GMT

I'm merging data from Access. I have some Yes/No (checkbox) fields. When I
merge the field into Word, it shows as True/False. I need this to be
displayed as a check box (form field), either checked or not. Any ideas on
how to do this?

Reply to this Message

Graham Mayor - 18 Apr 2006 05:57 GMT

You can use a conditional field to insert a checked or unchecked box
character from (say) the Wingdings font thus

{IF {Mergefield fieldname} = "True" "Put the checked box character here"
"Put the unchecked box character here"}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I'm merging data from Access. I have some Yes/No (checkbox) fields.
> When I merge the field into Word, it shows as True/False. I need this
> to be displayed as a check box (form field), either checked or not.
> Any ideas on how to do this?

Reply to this Message

Charles Kenyon - 18 Apr 2006 06:44 GMT

{ IF "{ MergeField YN }" = "True" "CheckedBox" "Unchecked Box" }

except you use checked and unchecked box symbols instead of the words.
Formfields don't work with merges.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!

My criminal defense site: http://addbalance.com
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> I'm merging data from Access. I have some Yes/No (checkbox) fields. When I
> merge the field into Word, it shows as True/False. I need this to be
> displayed as a check box (form field), either checked or not. Any ideas on
> how to do this?

Reply to this Message