Format a Form when a filter is active

Sue22

Registered User.
Local time
Today, 09:01
Joined
Mar 11, 2015
Messages
37
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
 
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?
 
Yes I could by I don't know how to do it
 
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:
Code:
Me.YourLabelName.Caption = "Filter applied"
Or
Me.YourLabelName.Caption = "Filter not applied"
 
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
 

Users who are viewing this thread

Back
Top Bottom