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.
 
Have you changed the CheckBoxName to the name of the object in your report?
 
Tes. That's why the error is so puzzling. I've double checked and the naming
is in order.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
text field to appear only if source value is "Yes" 2
CHECK BOX 1
check box 3
check box label to be visible and invisible 8
Access Create option group without using wizard? 2
Sum Check Box 5
text box and label control sources and concatenation 2

Back
Top