There is nothing built-in to Access that will allow you to change the color of command buttons.
Here are several options for you:
1. Use a label instead. Labels have click events and can be made to look like a command button with
some work.
2. Sensei Stephen Lebans has an example database that shows how to set a command button back color
and more:
http://www.lebans.com/cmdbutton.htm
3. There's a nice "Color Command Buttons" download at this site:
http://www.candace-tripp.com/access_downloads.htm
4. Some simple colored button examples that can be copied into your application are available at:
http://www.peterssoftware.com/clrbtn.htm
5. A shareware version of Button Painter for MS Access is available at this web site:
http://www.peterssoftware.com/bp.htm
Are you using the built-in Access Switchboard Manager?
If so, and you want to use the label option mentioned above, you will have to change one line of
code on the Switchboard form. Labels cannot receive focus so delete or comment out this line in the
FillOptions Sub:
Me![Option1].SetFocus
Alternatively, set the focus to some other object on the form that can receive the focus. You could
make a small text box with 0" height and width so it's virtually invisible and set the focus to that
in the FillOptions Sub.
--
Jeff Conrad
Access Junkie
Bend, Oregon
Install the latest Windows Updates:
http://www.microsoft.com/security/security_bulletins/200404_windows.asp