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

J

JohnLute

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

THANKS!
 
J

JohnLute

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?
 
O

Ofer

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)
 
J

JohnLute

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.
 
J

JohnLute

Tes. That's why the error is so puzzling. I've double checked and the naming
is in order.
 
O

Ofer

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?
 
Top