Hello,

Is there a way to change the color of text in certain fields after a find is performed? I've tried finding the records I want & then using the replace feature but this only works if the text is the same. I am working with a housing database. When I search for rooms in one area, I would like those rooms found to be color coded. For example, If I search for rooms in the east wing (which is a field called area) I would like the room numbers(in the room numbers field) for the east wing rooms to display as red. If I search for rooms in the west wing,I would like the room numbers for the west wing rooms to display as blue. I have 2000 records and about 10 different areas to chose from. Any suggestions, or is this a lost cause???

Make a global text field gRooms

Make a calc

Case (PatternCount (gRooms, Area)>0, RoomNumber)

This calc will return the room number only when the area chosen in the global field matches with the area in whioch the room is located

A nice addition might be to format gRooms as a checkbox field so that you might choose multiple areas and highlight relative rooms

(Hope I understood properly)