check boxes...

[dodgyone]

On the report I want to look at a check box... if it is checked then leave everything as is but if not then display a lable (make label visible) that has a message inside.

THanks....

 

[dodgyone]

I've tried this code on report open...

If Me.Gas = True Then
Me.NA.Visible = True
Else
Me.NA.Visible = False
End If


...but no joy... any ideas?

 

[Maquis]

Put your code in the on_format event instead of on_open. Maq B-)
<insert witty signature here>

 

[dodgyone]

There isn't an on_format event in the report page properties window!

I'm using Report_Open at the moment and that doesn't work!

Cheers for getting back to me...

 

[Maquis]

It's there. It's in the detail properties. Maq B-)
<insert witty signature here>

 

[dodgyone]

Thanks Maquis... looking totally the wrong place. It's working great ;o)

Cheers ears....!