Date field is null

[fishhead]

Hi can someone suggest how to write an "if" stmt that will run a command if a date field is empty (null)?

so far what i'm using is :



ifForms![fWireCreate]![fWireAPUnpaid].Form![WireDate] =null
runmacro mwires.pymt

I'm having difficulty if [wiredate] is empty, any ideas?

thanks in advance.

[Bob Fitz]

Either:

If IsNull(Forms![fWireCreate]![fWireAPUnpaid].Form![WireDate])

Or

If Forms![fWireCreate]![fWireAPUnpaid].Form![WireDate] Is Null

[Micron]

To elaborate on the response, nothing can be compared to Null
ifForms![fWireCreate]![fWireAPUnpaid].Form![WireDate] =null

Nothing is equal to, less than, greater than, not equal to, etc. - Null

IsNull is for typically for vba; Is Null for sql. One of those should work, but the one you need isn't obvious from your post.

[Missinglinq]

Assuming that the Control is on the same Form where the code is being executed...to validate whether a Control is populated or not, the Control to use is the Form's BeforeUpdate event. If you try doing it with an event tied to the Control, and the user simply doesn't enter the Control, your validation will be defeated...which is to say it'll never be executed. The code would be something like this:

Private Sub Form_BeforeUpdate(Cancel As Integer)
  If IsNull(Me.WireDate) Then
   'Do your code here
   End If
End Sub

If your situation is different...as @Micron suggested, you need to let us know what your scenario is, in plain language, as it isn't clear from your post.

Linq ;0)>