Change font color of text box, based on variable

[laavista]

I have a text box on a form and would like to change the forecolor to black or white (so the text is invisible) based on a variable.

I tried using the conditional formatting feature.


If MyVar = "Y" then do the conditional formatting.
In conditional formatting , I tried
1) Expression is MyVar = "Y" (it interpreted this as "MyVar" = "Y")
2) Expression is '" & MyVar & "' = "Y" (didn't work)

I also tried putting it in the code. On click of a different button, I tried:
1) txtMyTextBoox.ForeColor = RGB(255, 255, 255) (didn't work)
2) txtMyTextBox.ForeColor = vbBlack (didn't work)


Any suggestions?

[laavista]

I figured it out.

A public variable cannot be used in a form "as is". You have to call it from a function (.e.g., = getMyVariable).

Once I did this, the .forecolor worked with my text box.

[RuralGuy]

I'm glad you got your code working but what you state about public variables is not true.

[laavista]

Thanks for the info on public variables. I read that on the internet somewhere. Should have checked it out before posting that!

At least I did get the code working.