Microsoft KB Archive/293508

= ACC2000: How to Export a Check Box on a Report by Using OutputTo =

Article ID: 293508

Article Last Modified on 11/25/2002

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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([ ]=True,&quot;&quot;,&quot;o&quot;)

where is the name of the Yes/No field in the table, &quot;&quot; is the key combination ALT+0254, and &quot;o&quot; 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.

Keywords: kbhowto KB293508

-

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

© Microsoft Corporation. All rights reserved.