Is null problem

[rockape]

Hi,

a slight problem:

I have included this event procedure

Private Sub person_BeforeUpdate(Cancel As Integer)
If Me![person] Is Null Then
MsgBox "Please enter details"
Cancel = True
End If
End Sub

Basically I'm to ensure that a name is entered in the field. It won't work. Any clues someone?

Cheers

[RuralGuy]

I thought I had answered this somewhere.

Private Sub person_BeforeUpdate(Cancel As Integer)
If Len(Me.person & "") = 0 Then
   MsgBox "Please enter details"
   Cancel = True
End If
End Sub

[rockape]

I thought I had answered this somewhere.

Private Sub person_BeforeUpdate(Cancel As Integer)
If Len(Me.person & "") = 0 Then
   MsgBox "Please enter details"
   Cancel = True
End If
End Sub

hi RG,

no luck. On enter the message will not appear and cursor moves along to next input box.

Not my day today!

[RuralGuy]

Move the code to the OnExit event instead. You do not get a BeforeUpdate event unless the control has been changed by the user in some way.

[rockape]

Thanks RG,

Your input has been invaluable and set me on the right track.

Advised to Code put in form instead of control:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Nz(Me.Person, "") = "" Then
MsgBox "Please enter missing details"
Cancel = True
End If

End Sub

Cheerio

[RuralGuy]

That is a good solution too.