Checking a forms fields for null

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi All,

I can think of a few ways to accomplish this, but would like to know of a
better way.

just like when you fill out forms on the web if the field is mandatory it
pops up a msg say somthing like "This field isn't optional" if it is left
blank. What is the best way to do this in access on a form?

I'm using now:

if ISNull(myFeild1) then
msgbox"Please fill in myFeild1"
end if
If ISNull(myFeild2) then
msgbox"Please fill in myFeild2"
end if
if ISNull(myFeild3) then
msgbox"Please fill in myFeild3"
end if
 
I use something similar to what you are suggesting however my validation if
more than one field is null it will list all the fields that are null. I
chopped a small bit of it below.

Dim strMsg As String

If IsNull(Me.Audit_nme) Then
Cancel = True
strMsg = strMsg & "Audit Name required." & vbCrLf
End If
If IsNull(Me.Combo61) Then
Cancel = True
strMsg = strMsg & "Auditor required." & vbCrLf
End If
If IsNull(Me.DateAudit) Then
Cancel = True
strMsg = strMsg & "Date Initiated." & vbCrLf
End If
If Cancel Then
strMsg = strMsg & vbCrLf & "Correct the entry, or press <Esc> to
undo."
MsgBox strMsg, vbExclamation, "Invalid entry"
End If
 
Back
Top