Filter By Form Color Change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top