they could've accidentally left it blank, but for the most part, they don't have complete information
the database (the one I'm working on now, and really, all of them) has about 50 fields, and 3 subforms
they don't always have all the info at the beginning (like all the 6 phone numbers, e-mail and the website, and some records won't ever have website), and they fill it in as they go on
but the integrity of the data is very important, I'm a perfectionist, and I agree with you here
and I've done my part to make sure it'll be as accurate as possible by making combo boxes in all possible fields, and by putting input masks and so on, but a user is still a user
and for this one, will it look like this?
If Not IsNull(X_Code) Or X_Code = "" Then
Null_X_Code = False
Else
Null_X_Code = True
End If
If Not IsNull(FirstName) Or FirstName = "" Then
Null_FirstName = False
Else
Null_FirstName = True
End If
If Not IsNull(LastName) Or LastName = "" Then
Null_LastName = False
Else
Null_LastName = True
End If
and so on for all fields?
and I'll post my other question a little later and will give a link here