Conditional Formatting

[Guest]

Hi,

I am trying to find out if this is possible to do. I have a text field
called Price in my Main form and a text field called Cost in a subform. I
want the Price field in the Main form to turn a different color when the
field is LESS than the Cost field in the subform. Can this be handled in the
conditional formatting setting or by code?

Thanks for any input.
Bruce D.

 

[Steve Schapel]

Bruce,

Yes, I think this should work ok. Use Conditional Formatting for the
Price control on the main form, and put the equivalent of...
Exprression is ... [Price]<[NameOfSubformControl]![Cost]