Conditional formatting

[Ivor Williams]

I have a continuous form in which I compare values in two fields. If the
value in field two is greater than the value in field one, I want to change
the forecolor in field two to red. So far, everything I've tried has
resulted in all or none of the records changing color. Is there a way in a
continuous form to accomplish this at a record level rather than at a form
level?

 

[Ken Snell]

Conditional formatting should work for what you want. This is available for
ACCESS 2000 and higher versions.

You must use the names of the fields to which the controls are bound, not
the names of the controls.

Are the controls bound to a field? Or are they unbound?