Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Iggies
 
Posts: n/a
Default Yes/No Fields in Mail Merge?

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?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default Yes/No Fields in Mail Merge?

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

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



Iggies wrote:
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?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Charles Kenyon
 
Posts: n/a
Default Yes/No Fields in Mail Merge?

{ 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

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.


"Iggies" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I use mail merge fields with charts in Word? Kim HR Mailmerge 7 March 18th 10 12:44 PM
Mail Merge fields merge with different formatting KP Microsoft Word Help 1 February 22nd 06 12:01 PM
Mail Merge Numeric Merge Fields Patti - Hexagon Mailmerge 7 December 5th 05 01:28 PM
Mail merge - use specific fields in the contacts folder to customi Rachelle Mailmerge 1 November 29th 05 01:49 PM
mail merge not showing fields from outlook contacts Drew Mailmerge 2 January 27th 05 05:57 AM


All times are GMT +1. The time now is 10:03 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"