Yes/No Fields in Mail Merge?

[Iggies]

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?

 

[Graham Mayor]

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Charles Kenyon]

{ 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.
--
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




--------- --------- --------- --------- --------- ---------
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.