Highlight filtered fields with Filter By Selection

[wpilgri]

I have a simple form that shows approx 20 fields. Our users can filter using the "Filter By Selection" or the "Filter by Form" feature.

What I would like to do is be able to highlight any field that is part of the active filter. The problem we have now is that it is not entirely obvious what fields are involved in the filter and the highlighting would make that very clean.

Is there an event or property that I can use to find out which field(s) are currently filtered? There is the "OnFilter" event for the form but I don't see how I can use it to determine which fields are involved in the filter.

Thank You

 

[PHV]

I'm afraid you have to parse the Me.Filter string.

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

 

[wpilgri]

That appears to work for "Filter by Form", but I am using the Form.Filter event and it does not fire for the "Filter By Selection". Any suggestions on how to catch a change when using filter by selection?

Thank You