How to have a from label appear based on a value in a check box

[Guest]

Any help with how to code a lable in a form so that it only appears when a
check box in a subform is checked?

 

[Duane Hookom]

You can change the label to a text box and set its control source to
something like:
=IIf([checkbox],"Your Caption","")

 

[Guest]

That didn't seem to work. It just shows #Name? in the field regardless of
the value in the check box. Here's the language I used

=IIf(

![CheckBox]=-1,"Caption","")

I also tried

=IIf(

![CheckBox]=Yes,"Caption","")

But, in either case, the text box would still be visible all of the time,
and that's what I trying to avoid. Any thoughts?

You can change the label to a text box and set its control source to
something like:
=IIf([checkbox],"Your Caption","")

--
Duane Hookom
MS Access MVP

Any help with how to code a lable in a form so that it only appears when a
check box in a subform is checked?

 

[tina]

the problem is in your syntax, you can't refer to a table like that, within
a form. you need to refer to the checkbox within the subform, via the
subform control. try

=IIf([NameOfSubformControl].[Form]![CheckBox],"Caption","")

and btw, as Duane's expression showed, you don't need to include the "=-1"
in the IIf() function's first argument, because a checkbox's value is
already boolean (true or false).

hth

That didn't seem to work. It just shows #Name? in the field regardless of
the value in the check box. Here's the language I used

=IIf(

![CheckBox]=-1,"Caption","")

I also tried

=IIf(

![CheckBox]=Yes,"Caption","")

But, in either case, the text box would still be visible all of the time,
and that's what I trying to avoid. Any thoughts?

You can change the label to a text box and set its control source to
something like:
=IIf([checkbox],"Your Caption","")

--
Duane Hookom
MS Access MVP


in message news:[email protected]...

Any help with how to code a lable in a form so that it only appears when a
check box in a subform is checked?

 

[Ron2005]

And alternative:

Have the default for the label be NOT visible.

on the check box afterupdate event AND the form OnCurrent event:

me.labelname.visible = me.chkbox


If the chkbox has been checked (true) then the label is visible
otherwise it is not visible

 

[tina]

yes, that alternative will work, but since the label is in the main form,
and the checkbox is in the subform, the correct syntax would be

me.parent.labelname.visible = me.chkbox

hth