Check Box Question

[Bob V]

Can my form have this code something like this!
If cbRemark = -1 then tbRemark colour256

Trouble is that Conditional formatting does not have the colour I want
Thanks for any help..........Bob

 

[ruralguy via AccessMonster.com]

It can if you put the code in a separate sub and call it from the Current
event of the form as well as the AfterUpdate event of the "cbRemark" control.
You will need to properly address the property you want to change though.
(BackColor or ForeColor)

Private Sub ColorChange()

If Me.cbRemark = True Then
Me.tbRemark.ForeColor = 255
Else
Me.tbRemark.ForeColor = 0
End If

End Sub

 

[Bob V]

Thanks RuralGuy, Brilliant................Regards Bob
Private Sub Form_Current()

If Me.ckbRemindTogC = True Then
Me.tbRemindC.BackColor = 12189695
Else
Me.tbRemindC.BackColor = -2147483643
End If

End Sub

 

[ruralguy via AccessMonster.com]

If you make it a separate sub routine then you can call it from both the
Cerrent event of the form AND the Click event of the ckbRemindTogC control.

Thanks RuralGuy, Brilliant................Regards Bob
Private Sub Form_Current()

If Me.ckbRemindTogC = True Then
Me.tbRemindC.BackColor = 12189695
Else
Me.tbRemindC.BackColor = -2147483643
End If

End Sub

It can if you put the code in a separate sub and call it from the Current
event of the form as well as the AfterUpdate event of the "cbRemark"

[quoted text clipped - 17 lines]