I have a continuous form in which I want to color a textbox. The difficulty is that I have 5 different states - more than conditional formatting will handle. I have written a VB function and attached it to the control box. However, all the control boxes are colored based on the last record checked. How can I get a color for each record?