I have a continuous form with an unbound control that I want to change the backcolor of based on the value of the field. I don’t believe I can use conditional formatting because I need to find the backcolor value from a database table. I want to be able to set the color using VBA in the ‘on current’ event, but it changes the color for all rows in the form instead of just one. How can I do this?
