Hiding Checkbox if unticked

[Graham T]

Is it possible to hide a checkbox and it's associated label in a report if the checkbox is not ticked.

The report I have lists students followed by various checkboxes pertaining to different choices.

I would only like to show the checkboxes that are checked.

TIA

 

[Rich]

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

 

[Laocon]

Thanks Rich.

That answered one of my questions too!

 

[Graham T]

Thanks for the reply Rich

I suspected that this maybe the method.

A couple of further questions if possible:

1. Do I place this code in the On Open Event of the report?

2. When I enter this code I don't appear to have the Visible reference - do you know which reference I need to add?

When running the report I am getting the error:

Run-time error '2427'
You entered an expression that has no value.

And it is highlighting:

If Me.ysnIntTempDeny = False Then

TIA

Graham T

[This message has been edited by Graham T (edited 02-26-2002).]

[This message has been edited by Graham T (edited 02-27-2002).]