 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Set Property
I would like know how I can, using code change the background colour of a form, when a control on that from has a value set... e.g., I have a main from with an option control on it, when this control is set to inactive, I would like the main form background colour to be set. Can anyone help me. Regards - Paul Yes, you can do it. In the option control's After Update event, put this: Me.Detail.BackColor = WhateverNumberOfTheColorYouWant  SignatureBob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ > I would like know how I can, using code change the background colour of a > form, when a control on that from has a value set... [quoted text clipped - 5 lines] > > Regards - Paul Oops, forgot one piece: If Me.YourOptionGroupName = 2 Then ' (assuming 2 is the value for INACTIVE) Me.Detail.BackColor = WhateverColorNumberYouWantHere Else Me.DetailBackColor = WhateverColorNumberYouWantWhenNOTInactiveHere End If SignatureBob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ > I would like know how I can, using code change the background colour of a > form, when a control on that from has a value set... [quoted text clipped - 5 lines] > > Regards - Paul |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.