Conditional Format for Background Color

C

Chip

Hi All!

I have a form with a check box on it. Is it possible to
have the background for the form change color depending if
the check box is checked or not?

For example, the background color would remain green if
the checkbox is unchecked but will turn white once the
check box is checked.

Is this possible?
And how? :)

A thousand thanks in advance!
--Chip
 
D

Damon Heron

Put the following code in the click event - change backcolor numbers to your
own...

Private Sub Check4_Click()
If Me.Detail.BackColor = 32768 Then
Me.Detail.BackColor = 255
Else: Me.Detail.BackColor = 32768
End If
End Sub

HTH
Damon
 
C

chip

Thanks!

-----Original Message-----
Put the following code in the click event - change backcolor numbers to your
own...

Private Sub Check4_Click()
If Me.Detail.BackColor = 32768 Then
Me.Detail.BackColor = 255
Else: Me.Detail.BackColor = 32768
End If
End Sub

HTH
Damon




.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create bulleted to-do list using two styles? 5
Upgraded from Win 7 to Win 10. Publisher printing black. 1
Formatting issue in Word 2011 2
Access 2010 Form Background Color Not Changing with Themes 1
Excel does not accept text format! 0
Change text box background color depending on value in Label Reports 0
Conditional formatting of detail section in an access form 4
conditional format - table - cell empty return default color 1

Top