I am trying to do something that should be way easier than it is (and probably is easier). I want to change the background color on a textbox based on its value. I don't want to use Conditional Formatting because I need to learn the VBA to do it. I've used conditional formatting before and that's great. I'm working with more advanced formulas to determine color, and want to do it in VBA.
Amount is of type Currency, if that matters. Code is below.
The textbox format default back color is not transparent; it's set to Normal.
It simply doesn't work. All my values are positive dollar amounts. Once I get this to work, then I'll play more. What I'd love to see is all of the Amount fields to be red. Now, they're all white.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Amount > 0 Then
Me.Amount.BackColor = RGB(240, 0, 0)