Checkbox On Report And Excel

[Barry Alkis]

I have a number of checkboxes on a report and my user
wants to export the report to excel. These checkboxes do
not display in the spreadsheet. I searched and found an
article that indicated the following:

"To export a check box on a report so that it appears in
an RTF file:
Create a text box on the report.
Set the FontName property of the text box to Wingdings.
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"

I did this. The text field displays in the repot
unchecked and in the spreadsheet, but when I check a
checkbox, the textbox does no display. It only displays
when it is unchecked.

Can anyone help with this ?

 

[SA]

Barry:

Really all these check boxes are, are visual representations of a boolean
value i.e 0 or -1; you should expect to export that value to Excel; you can
format Excel to display it as TRUE/FALSE once the export is done.