Null Date control code problem

[DanW]

Hi and thanks for your help in advance.

I have not been able to code for the condition of a null date control. I have a date control and an unbound text box with an expression that calculates the number of months since the date entered in the date control.

I have been able to code for different effects on a form whether the calculated text box is below or above a number of months. But if the date and calculated controls are empty, I get the effects I wanted if the number in the calculated control was higher than my dividing line.

I would like to have a different set of effects on the form if the date control is empty, but have tried everything I can think of to define that empty data state without success.

This is what works now, where the Null state returns the Else effect.

If Me.txtDateDiff <= 10 Then


Code for Effect 1
Else
Code for Effect 2
End If



This is what I would like to have, but doesn't work.

If Me.txtDate is Null Then
Code for Effect 0
ElseIf Me.txtDateDiff <= 10 Then
Code for Effect 1
Else
Code for Effect 2
End If

What am I missing?

[NTC]

If IsNull(Me.txtDate)Then
Code for Effect 0
End If
If Me.txtDateDiff <= 10 Then
Code for Effect 1
Else
Code for Effect 2
End If

[DanW]

That worked NTC
Thanks for getting me past that.