Changing font based on selection

[darkmage1]

I have a combo box on my main form with the values: Not in collection, In Collection. If I choose the section "In Collection" from my combo box I would like the font color of that particular record in my text box named "Title" to change to black. if I choose the selection "Not In Collection" from my combo box I would like the font color of that particular record in my text box Named "Title" to change to red. I am not sure how to do this.

 

[PHV]

Have you tried conditional formatting ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[darkmage1]

How would I do this conditional format? My combo box is named "Status" and my textbox is named "Title".