Checkboxes don't print on report in 97 Access 1

[Jim0845]

I have a report that has checkboxes. When I preview the report in Access and send it directly to the printer, they are there, along with the checkmarks in the boxes if there are any.

When I save or send the report as an rtf file the checkboxes or checkmarks are not there. I saw one posting that referred to using different fonts to get the checkboxes to print, but I have been unable to figure out exactly what they did, or where in Access to change the font of the checkbox or checkmark.

Am I trying to do something that can't be done? If I can make the checkboxes and marks show up on the report in rtf files that will be the simplest solution.

All suggestions greatly appreciated.

 

[Remou]

I don't think that this can be done with an rtf. Would Yes or No suit?

=Format([CheckFieldNameHere],"Yes/No")

http://lessthandot.com

 

[dhookom]

You can set the Font of a text box to a font like Wingdings that has a check mark as a character (maybe a lower case "a"). Then set the control source to
=IIf([Your Field Name], "a", "c")
There are other fonts with different styles of boxes and checks.

Duane
Hook'D on Access
MS Access MVP

 

[Jim0845]

Thanks for the suggestion Remou. That is a more practical workaround than what I was considering and because of some other issues, that may be what I wind up doing.

dhookum, I finally understand how to use the Wingding font to do what I need, although I used Webdings and =IIf([Field_Name]=True,"a"). However, due to other rtf limitations I am going to have to figure something else out.

Thanks to both of you for your suggestions.