format fields based on filter?

C

Cam

Hello,

I have a form with several fields that can be filtered. I would like to put
in a VBA in ON OPEN or ON LOAD, so if any field is filtered (or if they have
the same records), then disabled that field or change the background color of
that filtered field?
What to put in the code to achieve this? Thanks
 
A

Alex Dybenko

Hi, perhaps you can use conditional formatting? you can make a new
calculated field in underlying query, which will indicate that field(s) is
filtered, and then use it in conditional formatting expression

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Top