How do I show a check box only if the Value is yes 2

[czarjosh]

I have a check box field on a report, and I only want it to be visible IF the value of the field equals YES. How can I accomplish this.

 

[dhookom]

You can add code to the On Format property of the section containing the check box:
Me.[chkMyCheckBox].Visible = Me.[chkMyCheckBox] = -1


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Wes1961]

Duane,

Found the answer to my question by searching past post.
Here's your star for helping me.

Wes

 

[ProgramError]

A neat way is...
=IIf([value]=True,"i can read this","")

put this in the control source of a textbox put on the report...

substituting "value" for the checkbox name
and "i can read this" for the text you want to display



Program Error
Why is it, I still think in terms of spectrum BASIC!