How to determine if a "date" field is null 1

[john765]

I'm new at this game and cannot find any hints on this. Please can someone tell me how to determine if a date field is empty (null) before I update another field.

Thanks in advance.

 

[LittleSmudge]

It depends

do you have the field accessible in a recordset
or is there a control on a form that is bound to this field ?


If, as I suspect, you have a text box control on a form that is bound to the field you want to test then you just check the contents of the control.

If IsNull(textboxname) Then
    ' Do the IsNull action
Else
    ' Do the not Null action
End If

Where you put the above code depends on when you want to do the check - when event has given rise to you needing to do the check.



'ope-that'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.