check box label to be visible and invisible

[Guest]

I have a text box named Label220 with the control source:
="Inactive Date "+IIf(IsNull([InactiveCheck] & [InactiveDate]),Null,"")

[InactiveCheck] is a check box and [InactiveDate] is a text box. When the
report is executed Label220 appears even when [InactiveCheck] has no value.

Is Label220 appearing because [InactiveCheck] is a check box and this
clashes somehow with the code? How can I correct this?

Thanks for your help!

 

[Guest]

Hi John,
I'm assuming that when the check box is true you want the label shown etc if
so what about trying the following in the checkbox update

If InactiveCheck = True then
InactiveDate.visible = True
Elseif InactiveCheck = False Then
InactiveDate.visible = False
End if

Cheers

 

[Allen Browne]

If InactiveCheck is a bound to a Yes/No field in your table, it will never
be Null.

Post a reply, John, if that's not the issue.

 

[Guest]

Thanks, Wuelf. Yes - I want the label to show only when there is a value in
the checkbox, however, what Allen posted regarding the box being linked to a
Yes/No field comes into play as this is the case and therefore, the field
will never have a null value. I've asked Allen if this can be worked around.

Thanks, again!

--
www.Marzetti.com

Hi John,
I'm assuming that when the check box is true you want the label shown etc if
so what about trying the following in the checkbox update

If InactiveCheck = True then
InactiveDate.visible = True
Elseif InactiveCheck = False Then
InactiveDate.visible = False
End if

Cheers

I have a text box named Label220 with the control source:
="Inactive Date "+IIf(IsNull([InactiveCheck] & [InactiveDate]),Null,"")

[InactiveCheck] is a check box and [InactiveDate] is a text box. When the
report is executed Label220 appears even when [InactiveCheck] has no value.

Is Label220 appearing because [InactiveCheck] is a check box and this
clashes somehow with the code? How can I correct this?

Thanks for your help!

 

[Allen Browne]

John, I didn't see your reply yet, but perhaps:
=IIf([InactiveCheck], "Inactive Date " + [InactiveDate], Null)

 

[Guest]

Hi, Allen. Yes - it's bound to a Yes/No field. Is there any way around this?

Thanks!

--
www.Marzetti.com

If InactiveCheck is a bound to a Yes/No field in your table, it will never
be Null.

Post a reply, John, if that's not the issue.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a text box named Label220 with the control source:
="Inactive Date "+IIf(IsNull([InactiveCheck] & [InactiveDate]),Null,"")

[InactiveCheck] is a check box and [InactiveDate] is a text box. When the
report is executed Label220 appears even when [InactiveCheck] has no
value.

Is Label220 appearing because [InactiveCheck] is a check box and this
clashes somehow with the code? How can I correct this?

Thanks for your help!

 

[Guest]

Thanks, Allen. This returns the field data but the label doesn't appear.

???

--
www.Marzetti.com

John, I didn't see your reply yet, but perhaps:
=IIf([InactiveCheck], "Inactive Date " + [InactiveDate], Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks, Wuelf. Yes - I want the label to show only when there is a value
in
the checkbox, however, what Allen posted regarding the box being linked to
a
Yes/No field comes into play as this is the case and therefore, the field
will never have a null value. I've asked Allen if this can be worked
around.

 

[Allen Browne]

Let's see if I understand your aim, here John.

Label220 is a text box.

If the yes/no field named InactiveCheck is True, you want to see:
Inactive Date 1/1/2005

If InactiveCheck is False, you want Label220 to be null.

Try:
=Iff([InactiveCheck], "Inactive Date " & [InactiveDate], Null)

If I have not understood you, please clarify for me.

 

[Guest]

Thanks, Allen.

I think I'll simplify and refocus my aim. I need to create a label for
[InactiveCheck] only.

I think I was trying to make one text box do too much. I modified your code:
=IIf([InactiveCheck], "Inactive Date ", Null)

That works fine.

Thanks for all your help!!!

--
www.Marzetti.com

Let's see if I understand your aim, here John.

Label220 is a text box.

If the yes/no field named InactiveCheck is True, you want to see:
Inactive Date 1/1/2005

If InactiveCheck is False, you want Label220 to be null.

Try:
=Iff([InactiveCheck], "Inactive Date " & [InactiveDate], Null)

If I have not understood you, please clarify for me.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks, Allen. This returns the field data but the label doesn't appear.

???