VBA as listed
Private Sub IndStatmentHandwrittenComment_BeforeUpdate(Cancel As Integer)
If Forms!WindOptOutV12.IndStatmentHandwrittenComment = "" Or Null Then
MsgBox "Please Enter a Comment Below for Deviations listed as OTHER"
Else
End If
End Sub
I have a field above this where if the selection = Yes then the comment box becomes visible. I have tried on focus/lost focus before/after but only had luck on the lost focus event when i populated it with a word and then deleted the word and tried to go to the next field. Basically deleting the default would trigger the original lost focus "" or null. When I remove a default value and click in the cell and go to another I cannot get the msgbox to pop up. Any help/suggestions on this are appreciated.
I have used me.dirty on a form however is there a way to set if fieldname.dirty = false then
msgbox?
or is this the wrong direction
Private Sub IndStatmentHandwrittenComment_BeforeUpdate(Cancel As Integer)
If Forms!WindOptOutV12.IndStatmentHandwrittenComment = "" Or Null Then
MsgBox "Please Enter a Comment Below for Deviations listed as OTHER"
Else
End If
End Sub
I have a field above this where if the selection = Yes then the comment box becomes visible. I have tried on focus/lost focus before/after but only had luck on the lost focus event when i populated it with a word and then deleted the word and tried to go to the next field. Basically deleting the default would trigger the original lost focus "" or null. When I remove a default value and click in the cell and go to another I cannot get the msgbox to pop up. Any help/suggestions on this are appreciated.
I have used me.dirty on a form however is there a way to set if fieldname.dirty = false then
msgbox?
or is this the wrong direction