What value is in an untouched field in a new record?
I thought it was Null, but this test is telling me it isn't..
Clicking that box gives me "ia <> null ". (Google search is unproductive.)Code:Private Sub initialActivity_Click() Dim tempInitAct As Variant tempInitAct = Nz([INITIAL_ACTIVITY]) If tempInitAct = Null Then MsgBox ("ia = null " & tempInitAct) Else MsgBox ("ia <> null " & tempInitAct) End If End Sub