Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: How to Export a Check Box on a Report by Using OutputTo

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

View products that this article applies to.

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).

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB293508, kbhowto

↑ Back to the top

Article Info
Article ID : 293508
Revision : 1
Created on : 11/25/2002
Published on : 11/25/2002
Exists online : False
Views : 271