WD2000: How to Show Access Check Boxes During a Mail Merge (211300)



The information in this article applies to:

  • Microsoft Word 2000

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.

Modification Type:MajorLast Reviewed:12/6/2000
Keywords:kbhowto kbinterop kbmerge KB211300