Conditional formatting on a label?

[Laurel]

I want a label or an unbound text field, if that's the way to go, to not
show up under certain conditions. Can I use the "conditional formatting"
menu item to do this?

1 - There doesn't seem to be a visible/invisible choice, just
enabled/disabled
2 - Conditional formatting seems to be disabled for label controls. But if
I use an unbound text box, I can't put the text in it, as it causes a
dialogue box to show up at run time.

 

[ErezM via AccessMonster.com]

you can use an unbound textbox (set it's value to ="The Value" - i mean use
quotes otherwise access thinks it's a variable or function name)
then set it's Enabled to false and it's Locked to true (so the user
experiences it as a label and not a textbox)

now for hiding, use your own picked backcolor for the form (because the
default one may change from one pc to another)
now set the textbox's bordercolor to transparent and backcolor to transparent,
and now use the conditional formatting to set the forecolor to the same color
as the form's backcolor (which means the text will "disappear")

good luck

 

[Laurel]

Oh, wow. I never would have figured this out! Thanks much!!!!

 

[Laurel]

I put the text for the unbound text field in the control source enclosed in
both single and double quotes, but I still get the input dialogue box when I
run the report. Ideas?

 

[ErezM via AccessMonster.com]

something else is wrong then, (i just re-checked to be sure) on bothe form
and report, and unbounc textbox with it's controlsource set to ="label" (the
equation and then double quoted string) and it doesnt ask you for anything
else,
which means you have a problem with: 1. another control on the form 2. the
record source for the form 3. one of your conditional-formatting conditions

I put the text for the unbound text field in the control source enclosed in
both single and double quotes, but I still get the input dialogue box when I
run the report. Ideas?

you can use an unbound textbox (set it's value to ="The Value" - i mean
use

[quoted text clipped - 22 lines]

 

[Laurel]

I neglected to pu the = sign in front of it.

something else is wrong then, (i just re-checked to be sure) on bothe form
and report, and unbounc textbox with it's controlsource set to ="label"
(the
equation and then double quoted string) and it doesnt ask you for anything
else,
which means you have a problem with: 1. another control on the form 2. the
record source for the form 3. one of your conditional-formatting
conditions

I put the text for the unbound text field in the control source enclosed
in
both single and double quotes, but I still get the input dialogue box when
I
run the report. Ideas?

you can use an unbound textbox (set it's value to ="The Value" - i mean
use

[quoted text clipped - 22 lines]

I use an unbound text box, I can't put the text in it, as it causes a
dialogue box to show up at run time.