make a check box appear only when source has a "Yes" value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I make a check box appear only if its source has a "Yes" value? Is
this possible?

THANKS!
 
I found the answer to this with a search. I'm using the format event of the
report's detail.

This brings up another challenge. How do I make the check box shrink?
 
Why do you need it to shrink if you dont display it when its false

On the Format event of the detail section, you can write the code
me.CheckBoxName.Visble = iif(me.CheckBoxName is null, False,me.CheckBoxName)
 
Thanks, Ofer! I need it to shrink so that it won't take up any report space.
I have several check boxes and each one takes up space that I want to be able
to condense.

The code you supplied seems to produce an error: RunTime Error 424 Object
Required.

This doesn't make sense to me.
 
The check box doesn't have a can shrink property, but you can make it visible
false, and set the can shrink propert of the section whrere the check box is,
to yes.

About the error, can you post the code you have, and did you define it in
the code section?
 
Back
Top