ACC2000: How to Export a Check Box on a Report by Using OutputTo (293508)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q293508
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SUMMARY

A check box on an Access report cannot be exported to the RTF, Excel, text, or HTML file format because a check box is a graphic.

MORE INFORMATION

To export a check box on a report so that it appears in an RTF file:
  1. Create a text box on the report.
  2. Set the FontName property of the text box to Wingdings.
  3. Set the ControlSource property of the text box to the following function

    =IIF([<fieldname>]=True,"","o")

    where <fieldname> is the name of the Yes/No field in the table, "" is the key combination ALT+0254, and "o" is the lower case letter o.
The report will display either an empty box or a checked box. These characters can also be exported because they are actual font characters and not graphics.
Modification Type:MajorLast Reviewed:11/25/2002
Keywords:kbhowto KB293508
©2002 Microsoft Corporation. All rights reserved.