I have a report in Access 2003 where I want the back color of a text box to change based on the value in another text box. The code I'm using is shown below.
Option Compare Database
Private Sub Report_Open(Cancel As Integer)
If Me.txtQuartileCurrent.Value = 1 Then
Me.TxtCurrentMonthRanking.BackColor = 16711680
The field that populates txtQuartileCurrent has no nulls and I will expand the code to include values of 2, 3, and 4 when this error has been eliminated.
I compacted the file but no change in results. Any suggestions would be appreciated.