I have a subform in which is a continous form. The subform only has two controls, a text value and a numeric value. The numeric value is in a text box called "txtRoll". I want the line on the bottom of the subform's row (named "LineEvery5") to show conditionally if txtRoll = 30, 35, 40 or 45. As a line will not respond to conditional formatting (the option on the menu is "grayed out"), I tried the following code on the OnCurrent event of the subform. (I simplified the constraints as I was having trouble with the OR syntax)
Code:
If Me.txtRoll = 30 Then
Me.LineEvery5.Visible = True
Else:
Me.LineEvery5.Visible = False
End If
I also tried this.
Code:
If Me.txtRoll.Value = 30 Then
Me.LineEvery5.Visible = True
Else:
Me.LineEvery5.Visible = False
End If
Interestingly, in both cases, LineEvery5 disappears. If I comment out the code, LineEvery5 is visible on every row. Clearly I am not getting a "True" from my If clause. What code might give me a True when txtRoll equals 30, 35, 40, or 45?