Really need help with handling a null!

[Wag2016]

Hi Everyone.
I am working on a checklist with a question, a option group response (Yes, No, NA) and a Remark field. The remark field is required if No or NA are chosen.

I have code that turns the Remark field red from yellow if No or NA are chosen. (This red field will prompt them to end a remark). What I can't figure out is how to turn it back to yellow once they have entered a remark. Hope that makes sense.

What I have:

Private Sub SQ1F_Click()
If SQ1F = 2 Or SQ1F = 3 Then
Me.SQ1R.BackColor = RGB(255, 0, 0)
Else
Me.SQ1R.BackColor = RGB(255, 255, 204)
End If
End Sub

Please help - and thank you! :banghead:

 

[pbaldy]

Make your test

If (SQ1F = 2 Or SQ1F = 3) And Len(Me.Remark & vbNullString)=0 Then

And call it from both control's after update events.

 

[Wag2016]

Make your test

If (SQ1F = 2 Or SQ1F = 3) And Len(Me.Remark & vbNullString)=0 Then

And call it from both control's after update events.

Worked like a charm! My weary eyes thank you very much.

 

[pbaldy]

Happy to help!