in conditional formatting what would be the expression i would use to check whether a DIFFERENT textbox's font color is set to white?
+1
A:
With VBA, you can check whether a control's ForeColor property is white (vbWhite = 16777215).
If Me!SomeControl.Properties("ForeColor") = 16777215 Then
However, I'm lost trying to figure out how to apply that approach in conditional formatting.
HansUp
2010-07-07 17:46:17
hansup, yes i need this for conditional formatting
I__
2010-07-07 17:50:50
Yeah, I understood. My head exploded trying to work it into conditional formatting. Sorry.
HansUp
2010-07-07 17:53:53
ahahhahahahahhaahahahah
I__
2010-07-07 17:55:18
I'd recommend finding some other way around the issue. Like, what is the criteria for the other field's forecolor? Can you base your formatting off that?
PowerUser
2010-07-07 19:14:34
Would you not just use the same test that causes the other control to be rendered as white?
David-W-Fenton
2010-07-08 03:04:13