Mail merging of boolean data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Warren Siu - 02 Apr 2004 03:17 GMT

I am merging a boolean access data to word and supposed to
have a check box appear. However it only show with 0 or -
1, how can I turn them to check box or radio?
Thanks

Reply to this Message

Doug Robbins - Word MVP - 02 Apr 2004 03:34 GMT

Use and If...Then...Else statement to check the value in the field and have
it insert a Windings Characater 254 if the result is true or Windings 168 if
it is false.

Easiest way to set this up is use the If...Then...Else from the Word Fields
pulldown in the mailmerge main document and insert A for the true condition
and B for the false. Then press Alt + F9 to toggle on the field codes and
replace the A and B with the Wingdings characters.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>I am merging a boolean access data to word and supposed to
> have a check box appear. However it only show with 0 or -
> 1, how can I turn them to check box or radio?
> Thanks

Reply to this Message