Color flags

[EvilCabal]

Hello,

I have a form that shows some records in a datasheet view. What I would like to have is a little box on each line that takes a different color depending on the value of certain fields in the record. Is there a way to do this?

Thank you.

 

[PHV]

Perhaps a conditional format ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[EvilCabal]

Sorry maybe my question wasn't precise enough, it's obviously a conditionnal format but my problem is that the form uses the datasheet view so you see many records at the same time. So where do I put this conditionnal format?

The best I found is in the 'on current' event but then the color changes for every records each time I switch line because objects have only on value per property per form. So when I change the value, it changes for every record on the form.

Any clue?