Coloring one text box on a continous form

[bballpinhead]

I need to be able to color a single text box on a continous form based
on user criteria. I can't get this to work without it coloring every
text box whether it matches the criteria or not. If there are any
suggestions please help. Thanks

 

[Ofer Cohen]

Check this link about "Conditional Formatting and Continuous Forms"

http://www.databasedev.co.uk/conditional_formatting.html

 

[bballpinhead]

That could work but I need more than three conditions.

 

[Krizhek]

Heres a suggestion:

http://www.mvps.org/access/forms/frm0024.htm

I have never used these before but hopefully this will be of some help to you.