Discussion Locked
unbound controls with continuous forms
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?