Is null question

[gafort]

Sorry I am new. If the form field (email address) is null, how do I print a message box that says "Please enter a valid email address" with an option to enter the address OR click ok and have the cursor back in the "null field" to eliminate the run-time error?

[Missinglinq]

Here's some pretty standard code for doing that:

Private Sub Form_BeforeUpdate(Cancel As Integer)

 If Nz(Me.txtEmailAddress,"") = "" Then
   MsgBox "The Email Address Must Not Be Left Blank!"
   Cancel = True
   txtEmailAddress.SetFocus
   Exit Sub
 End If
 
End Sub

Simply replace txtEmailAddress with the actual name of your Control, on the Form, that holds the data.

Linq ;0)>

[gafort]

Thank you Linq, worked like a charm. I knew it was simple, just could not find it in the forum.

[Missinglinq]

Glad we could help!

Linq ;0)>