I have a report which shows the total time spent working by each user on a specified day. I want the text box, which shows the total hours worked on that day, to turn red if a user has not entered enough time for that day. Currently I have it set up so that a text box =sum([hours]) then on Report_Open
If Text19 < 4 Then
Text19.BackColo r = vbRed
Else
Text19.BackColo r = vbWhite
End If
It says that i entered an expression that has no value error 2427.
Anyone know how i can get this to work?
Thanks in advance
If Text19 < 4 Then
Text19.BackColo r = vbRed
Else
Text19.BackColo r = vbWhite
End If
It says that i entered an expression that has no value error 2427.
Anyone know how i can get this to work?
Thanks in advance