Checking fields null

[tambadal]

Private Sub Command228_Click()
'Save
On Error GoTo Command228_Click_Err

    On Error Resume Next
    DoCmd.RunCommand acCmdSaveRecord
    If (MacroError <> 0) Then
        Beep
        MsgBox MacroError.Description, vbOKOnly, ""
            End If

Command228_Click_Exit:
    Exit Sub
Command228_Click_Err:
    MsgBox Error$
    Resume Command228_Click_Exit
End Sub

How do you modify the code to where it will check these 4 fields "Debarred, Restricted, CommType, and Approval_Status" are null before saving.

 

[welshgasman]

I would use the BeforeUpdate of the form and use either ISNULL() or NZ() functions.

 

[Micron]

this looks like the same problem/question as your other thread
https://www.mrexcel.com/forum/microsoft-access/1114879-len-function.html