Check boxes on a report

[jeo]

If I wanted to do a .visible on certain fields if a field was not cheked, how would I do that?
I want to say if NotOnSite is checked, I don't want to display OnsiteAddress, Onsite City, Onsite State, Onsite Zip.
Using the -1 it said that the object I'm trying to use has no value.
Any help would be appreciated.
Thanks.

 

[WayneRyan]

jeo,

A couple of ways to do this:

First you can use the DetailFormat event:

If Me.CheckBox Then
   Me.SomeField.Visible = True
Else
   Me.SomeField.Visible = False
End If

Secondly, you can investigate Conditional Formatting. You can set a
field invisible if the CheckBox is False.

I think I'd prefer the DetailFormat event.

Wayne

 

[jeo]

Thank you for replying...
Never though it could be done like this.
Thanks!