Use IIF to control background color of calculated text field

jkejke · Feb 28, 2001

Is it possible to use IIF to control backgound color of a calculated text box on a form--do not think conditional formatting will work--have tried--

Psychpt · Feb 28, 2001

yes it is and quite easy too.

MyTxtBox.BackColor = IIF("your criteria", true color, false color)

HTH

jkejke · Feb 28, 2001

Thanks

Now that I look at what you sent--I think I had a severe
brain cramp..

Psychpt · Feb 28, 2001

happens to the best of us!