If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional formatting on a label?
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. |
#2
|
|||
|
|||
Conditional formatting on a label?
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 wrote: 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. -- May all beings be happy. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200907/1 |
#3
|
|||
|
|||
Conditional formatting on a label?
Oh, wow. I never would have figured this out! Thanks much!!!!
"ErezM via AccessMonster.com" u45095@uwe wrote in message news:988a7c64ac788@uwe... 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 wrote: 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. -- May all beings be happy. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200907/1 |
#4
|
|||
|
|||
Conditional formatting on a label?
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" u45095@uwe wrote in message news:988a7c64ac788@uwe... 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 wrote: 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. -- May all beings be happy. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200907/1 |
#5
|
|||
|
|||
Conditional formatting on a label?
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 Laurel wrote: 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. -- May all beings be happy. Message posted via http://www.accessmonster.com |
#6
|
|||
|
|||
Conditional formatting on a label?
I neglected to pu the = sign in front of it.
"ErezM via AccessMonster.com" u45095@uwe wrote in message news:989705ff15daa@uwe... 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 Laurel wrote: 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. -- May all beings be happy. Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|