Continuous Forms - Applying different Back Colour to Text Box

[SM]

Hi,

I'm using Access97 and I'm wondering if it possible to
conditionally format the Back Colour of a Text Box on a
Continuous form.

For example, if in one record a certain condition exists I
want to format the Back Colour red, but if the next record
meets another condition I want to format the Back Colour
green.

Any help is appreciated (even if the news is that this
isn't possible!)

Thanks!

Sean

 

[Guest]

I knew it had to be complicated! Thanks for the help!