Showing Check Boxes in RTF export format?

[Tony Tillyer]

Hi,

I'm using ACC97 and trying to work out how to display the results of check
boxes, on a Report, which I need to export in RTF (or HTML, XLS etc.)
format.

Each time I open the exported file, I can see my Field Names, but the check
boxes have disappeared. I've tried changes check boxes to radio buttons and
toggle buttons, but nothing shows up in any of the exported file formats.

Please don't tell me I have to change the original Field Type! :)

Thanks,

Tony Tillyer

[Bruce M. Thompson]

Tony:

Access' RTF export does not support graphics directly (that's what the checkbox,
radio buttons, etc. are - graphical representations of a value). You might
consider checking out the following page at Stephen Lebans' web site for a
possible solution:

http://www.lebans.com/ReportUtilities.htm

--
Bruce M. Thompson, Microsoft Access MVP
bthmpson@big~SPAM_NOT~foot.com
>>No Email, Please. Keep all communications
within the newsgroups so that all might benefit.<<

"Tony Tillyer" <ttil...@ford.com> wrote in message
news:a5cuei$de...@eccws12.dearborn.ford.com...

[Rick]

I have the same thing on some reports that I email to
people. One solution is to download and use 'snapshot
viewer' but if you are going to be sending them to people
that do not have that program you might consider replacing
the checkbox with text. I built text boxes with an iif
statement that says if the value is true display a 'y', if
the value is not true display and underscore '_'.

The report would look something like this:

NAME COMPLETE Y/N
Brown, Phillip Y
Carson, Alan ___
Johnson, Sarah Y
.
.
.

The entry in the text box is simply:

=IIf([Complete],"Y","__")

>.
>

[James Shreve]

Hi Tony

What I do that will give you better looking results is to:
I create a report with the checkbox as a text field on the report
set the visible property to NO
Create an unbound textbox with the control source to something like the
following

Option 1
=IIf([Checkbox]=-1,"X","") looks fine

Option 2
Set the font property to Wingdings or other similar font then I use
Character map to find the symbol I like such as a checkmark or box with an X
in it or any other character you want. Since the font is a True Type font
Access can export it to a RTF file. The object looks strange on the report
because all of character
=IIf([Checkbox]=-1,"ü","") looks better, works great and only takes 5
minutes if you type with one finger.

JimS...@earthlink.net

"Tony Tillyer" <ttil...@ford.com> wrote in message
news:a5cuei$de...@eccws12.dearborn.ford.com...