Crosstab Rpt with conditional formatting

[ellenr]

Boredom has set in and I am playing with a report. Crosstab report works, but I would like to print check mark if value is "X". Other values are "A" and "E" and they need to remain as they are. Any ideas? Thank you.

 

[CJ_London]

conditional formatting cannot be used to hide a value or print/not print.

also check boxes do not have a conditional formatting property.

what you can do in the report on format event for the relevant section where the checkbox is placed, is put some code to make a check box visible or not

 

[ellenr]

Sorry--I didn't adequately describe my report. The crosstab report displays "X", "A" or "E" (meaning present, absent or excused--coding I inherited) for the once per year event for the members of the group. I just decided a check mark would be more esthetically pleasing than an "X" to indicate present. There are no "checkboxes" in the crosstab report.

 

[CJ_London]

you can still do as I suggest, have check box, overlay on top of the field with X and in the format event make it visible (and the other field , hide).

You will need to set the checkbox to true, so set it's value to say 1=1

 

[ellenr]

I couldn't do as you suggested, CJ_London, but did get an idea from your post. Here is how I changed the X's to check marks:

 colname = "Col" + Format(intX)
            If Me(colname) = "X" Then
                Me(colname) = "P"
                Me(colname).FontName = "Wingdings 2"
            Else
                Me(colname).FontName = "Calibri"
            End If

The above code was added into the OnFormat of the detail section.