I have a form with a text box on it. The text box is bound to a field in the table on which the form is based. Nothing special there.
However, when I put the following code on the AfterUpdate event, it just fails to work. Nothing happens, and the message box does not appear. I know this code works, because it works on other controls.
Private Sub TextField_AfterUpdate()
If IsNull(Me.TextField) Then
MsgBox "This is a test.", vbExclamation, "Test"
UPDATE: If I change the data type from Memo to Text then it works. Am I not able to use this code on a memo field then?!
Edited by: Alpha7 on Thu Dec 1 10:34:15 EST 2005.