Need report to only print checked boxes

chrisvt

Registered User.
Local time
Yesterday, 19:38
Joined
Apr 21, 2009
Messages
22
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.
 
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
 
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?
 

Users who are viewing this thread

Back
Top Bottom