Those were just a few options that came to mind, not a complete listing. You can, i.e. create a label as a button and change its border style in the OnClick procedure that performs the 'real' task or draw a rectangular frame around it (invisible) and 'illuminate' it by selecting a color and setting the Visible property to True in the event procedure for a backlit effect or....
Here's a primitive example that makes a rectangle,SpecialEffect=Sunken, visible when the button is clicked:
cmdXXX_Click()
stDocName = "qryXXX"
DoCmd.OpenQuery stDocName, acNormal, acEdit
Forms!frmXXX!txtBacklitFrame.Visible = True
There are quite a few ways to achieve that 'Push' effect, just play with it to find the one you want.
If you find an easier solution I'd appreciate your posting it here.
This was hopefully a little help, let me know how it works, please.
Have fun,
TomCologne