How to show which fields have FilterOn?

[ppataki]

Dear All,

I have a continuous form and somehow I would like to recolour/highlight those fields where a filter is applied
(sometimes there are filters in even 5-6 fields and it is very annoying when you forget which fields you already applied a filter in)

Any suggestions please?
Many thanks in advance

 

[John Big Booty]

What is the code that you are currently using to apply your filters?

 

[ppataki]

No code, user right clicks on the desired field and chooses filter
This is done on multiple fields and I would like Access to somehow indicate on each field if filter is on
Thx!

 

[JANR]

You could put a unbound textbox in your forms footer and set its controlsource to:

=IIF(Form.FilterOn,Form.Filter,Null)

The you can atleast read what the current form filter is set at.

JR

 

[ppataki]

Thank you very much, that is a great solution!