Hi there, as you can tell I am having real problems with Conditional
Formatting.
I have overcome a lot of problems thanks to these forums, but am still
experiencing a few niggles.
I have a continuous form that shows multiple results gathered by results
from a combo box, if a tick box is ticked the record goes red. Via a unbound
textbox that if it equals -1 then the colour is changed.
The results are all locked so the record cannot be edited, however now when
I click on a record the whole record goes red (it is like the bacground text
box is being bought to the forefront), when I click onto another record in
the subform, that one goes red (as before) and the previous record is
returned to the correct view.
This problem only occurs on the current record, as when I add another record
and the subfrom is requeried, the record that is appended to the results is
completely covered in red (no information can be viewed until I click on to
another record).

Help!!!

TIA