Substitute certain values

[xyba]

I have a query and a linked report which has Yes/No fields from checkbox fields. What I want to do, if at all possible, on the report, is hide the No values from being visible on the report.

I still want the other fields of those records with No in that field to show (so just adding Yes as the criteria isn't going to work for what I'm after) basically so that the Yes values are more visible.

Is this possible?

 

[Ranman256]

in the detail band, ON PRINT event in the detail

chkBox.visible = chkBox.value

 

[xyba]

in the detail band, ON PRINT event in the detail

chkBox.visible = chkBox.value

In Detail of the report? I just tried it and it didn't work. That statement also doesn't appear to allow the Yes values to be visible on the report, or maybe I'm missing something?

 

[xyba]

Just re-read my original post and not sure if I've explained correctly.

Basically, on the report, if the value is No in certain fields, I want it replaced with a blank ("")