Conditional Formatting individual controls in a sub form

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have a main form with a sub form, the sub form is a
continuous form. I would like to change the apperance of
a text box in the sub form depending on wether a check
box is true or false.
I can get it to change but it changes the text boxes for
all displayed records not just the individual record i
have updated???

e.g.
work type work done
cleaning yes
cleaning no

display the work done text box = yes in green and the
work done = no in red
 
set the conditional format for the control that needs to be red or green
using the condition control with data = 0, control with data = -1
 
Back
Top