I am using a VB procedure to ensure that all the fields in a form are
populated before a save/close action is allowed. I'm using code like this:
If IsNull([First Name]) Then _
MissingFields = MissingFields & CRLF & "First Name"
If IsNull([Street Address]) Then _
MissingFields = MissingFields & CRLF & "Street Address"
CRLF is a variable containing Chr(10) and Chr(13). The MissingFields
variable is used in an error message box identifying which fields need to be
When the form is in Data Entry mode and a field is left blank, it works
fine. When the form is in Edit mode and the value in a previously populated
field is deleted, the IsNull() function does not recognize the field as null.
Why is this? Is there another function I can use which will work?