Microsoft KB Archive/211300

= WD2000: How to Show Access Check Boxes During a Mail Merge =

Article ID: 211300

Article Last Modified on 12/6/2000

-

APPLIES TO


 * Microsoft Word 2000 Standard Edition

-



This article was previously published under Q211300





SUMMARY
When you perform a mail merge using data from a Microsoft Access 2000 database, Microsoft Word displays fields from the database that have a Yes/No data type as a 0 or 1, rather than as a check box.

This article explains how to display a check box that is either cleared or selected (checked) rather than a 0 or 1.



MORE INFORMATION
To receive a check box instead of a 0 or 1 when you perform a mail merge using a Microsoft Access database, follow these steps:
 * 1) Open the main document for the mail merge, and then place the insertion point where you want the check box to appear.
 * 2) On the Mail Merge toolbar, click the arrow next to Insert Word Field, and then click If...Then...Else.
 * 3) Under If, in the Field name list, select the field name that is the check box column in Microsoft Access.
 * 4) In the Comparison list, select Equal to.
 * 5) In the Compare to box, type 0 (zero).
 * 6) In the Insert this text box, hold down ALT and on the numeric keypad, make sure NUM LOCK is turned on, and then type 0168 (ALT+0168).
 * 7) Select the symbol that appears in the Insert this text box, and press CTRL+D.
 * 8) In the Font list, select Wingdings, and then click OK. You should now see an empty check box.
 * 9) Under Otherwise insert this text, press ALT, and then on the numeric keypad, type 0254 (ALT+0254).
 * 10) Select the symbol that appears in the Insert this text box, and then press CTRL+D.
 * 11) In the Font list, select Wingdings, and then click OK. You should now see a check box that is selected (checked).
 * 12) Click OK. A check box will appear at the insertion point of the main document.
 * 13) Continue with the mail merge.

Keywords: kbhowto kbinterop kbmerge KB211300

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.