great! Thanks for your very prompt replies. Much
appreciated.
Sally
-----Original Message-----
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/20040 4_windows.asp
.