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?

2 replies

by c1980

Sorry, in a continuous form it is not possible to change the properties of each copy of a control individually....

This discussion is closed to new replies.