BackColor

[matrixindicator]

Hello,

I can't let work the code.
He said on BackColor property not found or working.
Is it a version matter (access 2003)

thanks, pat.

Private Sub Ctl30YN_AfterUpdate()

If Me.Ctl30YN.Value = True Then
   
   Me.[30CLOSE].BackColor = RGB(63, 200, 55)  'Green
   Me.[30CLOSE] = date()
   Else

End If
End Sub

 

[Remou]

Is 30CLOSE a textbox? Does vbGreen instead of RGB(63, 200, 55) work?

 

[matrixindicator]

[30CLOSE] is a textbox depending on a field.

If this won't work....

I tried conditional formatting in the menu and this works to color, date() function works.

 

[Remou]

I am not sure whether or not you have resolved this problem? It seems you are using a continuous form, if so, conditional formatting is the way to go.

 

[matrixindicator]

yep Remou, I usted conditional formatted, this works fine.