Changing a single records color

[bobsmallwood]

Is there a way to change the background color of a single record in a table based on the condition of one of the fields in the record. For example, could I change the background color of all the records in an address type table where the zip code is, say 60523, and leave the background color of all non-60523 records white?

 

[Kliot]

Yes, but keep in mind the table must be contained in a form. On the zipcode field's "New Value" event add the following code

method new(var event Event)
do
if self.value="60523" then
self.color = yellow
else
self.color = white
endif

endMethod

Hope this helps
Perrin