Format a Form when a filter is active

[Sue22]

Hi I have a database with a filter on the form which users can apply I know at the bottom of the form it highlights it as filtered but I want something a bit more prominent displayed on the form when a filter is active anybody any ides how I can do this??

Thanks

 

[JHB]

Can't you use a label on your form with some text like "Filter applied"/"Filter not applied" depending of, if a filter is applied or not?

 

[Sue22]

Yes I could by I don't know how to do it

 

[JHB]

Add/Create a label on the form, then when you apply/remove the filter set the caption of you label to "Filter applied"/"Filter not applied" depending of, if a filter is applied or not.
Something like:

Me.YourLabelName.Caption = "Filter applied"
Or
Me.YourLabelName.Caption = "Filter not applied"

 

[Sue22]

Yes a label like that is precisely what I would like BUT I don't know how to write the VBA to detect when the filter is applied and when it isn't

 

[jdraw]

Sue,
I recommend you do some serious google"ing re: MSAccess - Overview; Event Processing; vba.
Watch some youtube videos and/or work through some vba code examples.
Some links:
http://www.functionx.com/vbaccess/
http://www.simply-access.com/Form-Events.html
Good luck