email using RTF

S

Samuel

Hi all

When I email a report using the RTF option the report is missing the check
boxes that appear on the report

What can be done?

Thank you,
Samuel
 
R

Rick A.B.

Hi all

When I email a report using the RTF option the report is missing the check
boxes that appear on the report

What can be done?

Thank you,
Samuel
Click to expand...

Samuel,

I've gotten around this by using Yes or No instead of the checkbox. I
use the checkbox in the report query and then put an unbound field
where the checkbox would go and do the following.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If Me.Coll1GenED = -1 Then
Me.GenEd = "Yes"
Else: GenEd = "No"
End If


End Sub
GenEd is the unbound textbox on the report and Coll1GenEd is the
checkbox from the report query.

Hope this helps. Maybe someone out here has a better solution.

Rick
 
A

Arvin Meyer [MVP]

Check boxes are graphic elements and are not available using RTF, but you
should be able to use a font that displays a checkbox, or not depending upon
the value in the underlying field.
 
Top