Change of a Text Box Color:-

[sbaud2003]

Hi Sir's
Is there any method where a Text Box color can be changed. I.e if Present then BLUE and if Absent then RED

 

[tvanstiphout]

Yes. Look up "Conditional Formatting" in the help file.

 

[Gasman]

I seem to recall there is also the Format property?
@CJ_London is the expert on that option, where there are 3 or 4 settings?

 

[theDBguy]

Hi Sir's
Is there any method where a Text Box color can be changed. I.e if Present then BLUE and if Absent then RED

I guess you could also specify whether you want to change the background color or the text itself. Because, the first suggestion can do both, and the second suggestion can only do one: the text.

 

[sbaud2003]

I guess you could also specify whether you want to change the background color or the text itself. Because, the first suggestion can do both, and the second suggestion can only do one: the text.

Actully I want to mark absent with RED and Present with Blue. (TEXT) so pls help me how to do

 

[Gasman]

Actully I want to mark absent with RED and Present with Blue. (TEXT) so pls help me how to do

CF is probably the easiest way.