Label automatically on/off - Visible/invisible by status Checkbox

[Bram]

Hey!

My problem is:

In a report, i want:
- if checkbox (3- state.. but doesn't matter here) IS NULL i want that there comes also text visible in my report.

Can i play with a macro so that the text (i think with a label? wich is standard invisible) becomes visible in my report.

The problem also is that all that must be done at the same time when opening the report... and the checkboxes are in different subreport (also like the text i want in the subreports...)

Thx
Bram

[TheShabz]

checkboxes don't have null values. If it is unchecked, it is 0. If checked, -1.

What you want is something to the effect of:
If Me.chkBox = 0 Then
Me.LabelName.Visible = False
End If

[Bram]

checkboxes don't have null values. If it is unchecked, it is 0. If checked, -1.

What you want is something to the effect of:
If Me.chkBox = 0 Then
Me.LabelName.Visible = False
End If

Hey TheShabz,

Yes, I have 3state - checkboxes
0, -1, and Null

Thanks for the support, but i can't work with VB.
I work always with the macro's...

Is there a solution for also?

Thanks,
Bram

[TheShabz]

Didn' t know the third stage was a Null. Oh well. I'm the exact opposite of you. I don't touch the macros. If you're using the checkboxes to turn on/off a label, I would think you'd need it at two-stage anyway. There is a solution by using macros. I just don't know of it as I don't use macros.