Changing Look of a button

[Chris1977]

This is most likely a simple question for those that have used Access for a while but here goes.

I what to make a button appear depressed when clicked and normal when slicked again.

I have a button now that filters records by a field on that form and just what ensure they now they clicked the button.

Here is the code I have now which works and makes the button text turn red when depressed and black when not clicked.

FilterOn = False
If FCounter = 0 Then
Filter = "SupervisorID = " & Me!SupervisorID.Value
Me.cmdFilterAgentData.ForeColor = 255
FilterOn = True
FCounter = 1
Exit Sub
End If
FCounter = 0
Me.cmdFilterAgentData.ForeColor = 0

 

[WildHare]

If I understand what you want to do, one way to make this command button "look" like a toggle button (in when 'active', out when 'inactive"') is to use a real command button that's transparent, over top of a rectangle that looks just like a button. Then you can change the rectangle's SpecialEffect property to make the rectangle look sunken (2) or raised (1), e.g.

Me.Rectangle.SpecialEffect = 2


Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm