Filter By Form Color Change

P

pas926

When users are in filter by form mode I would like to change the background
of the form so they can see that they are in filter mode. I know the "look
for" is available on the screen but I would like something bigger. Does
anyone know how to go about this. Any help would be appreciated. Thanks in
advance. Paul
 
G

GraemeR

Hi Paul, you can use the Filter and ApplyFilter events to detaect entereing
and exiting Filter By Form mode.
Try this:

Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
Me.Detail.BackColor = -2147483633
End Sub

Private Sub Form_Filter(Cancel As Integer, FilterType As Integer)
Me.Detail.BackColor = 255
End Sub


HTH, Graeme.
 
Top