Need report to only print checked boxes

[chrisvt]

Hi all-

I have a form that contains a number of check boxes. As things are currently setup, when the user enters data into the form, the corresponding report shows ALL the check boxes, whether they were checked or not.

I'd like the report to show ONLY the boxes that were checked.

Would this be accomplished through an Iif statement somewhere?

Thanks.

 

[DCrake]

If the check boxes are embedded in your report then in the section where they appear you can code

Me.Checkbox.visible = me.checkbox

So if the checkbox has been ticked (True) then it is visible and vice versa.

David

 

[chrisvt]

Thanks, David.

I'm new to access so please bear with me...the checkboxes are embedded in the report, but when I go the Properties of the Detail section in which they appear, I don't know where to add the code. Do I go to the Event tab>>On Format?