conditional formating of query

[JSDART!!]

HI
I am working on a database that holds communications from treatment episodes.
the sub form holds the communications related to that client and that treatment episode.
when you enter a date into the communication record a mesage box asks if this is a new treatment episode and if yes opens a new treatment record. If it is the same treatment episode it just remind you that you are in the same treatment episode.
what i would like to do as an additional cue to the user is that once a client has been discharged from the episode that all communication records change color.
I can get the field that says dc to change color but I want all the fields in all the records from that episode to change color.
any ideas?
thanks

 

[whitesmoke]

you either have to change each field color one by one in code or create the form with a unbound field in the background covering all records that only changes color based on your criteria. do a search on background color change..

i've done it.. it's a pain, but will work. use it on the on current method.