if date field is not null

[krberube]

good morning all,
I am using the afterupdate event on this forms field. If this date field is NOT EMPTY, then i want the next field to be visible. Here is the code i have

If Me.quotedate = ????????? Then
Me.quotehow.Visible = True
Else
Me.quotehow.Visible = False
End If

I have done this with text fields where i have a defined data to be = to, but for a date field what do i put in ?????????? to show is not null?

Thanks
Kevin

 

[Brianwarnock]

Use If IsNull(Me.etc ) and switch your test
Brian

 

[Ukraine82]

If Not IsNull([quotedate]) Then
Me.quotehow.Visible = True
Else
Me.quotehow.Visible = False
End If

hth,
Michael

 

[Ukraine82]

sorry take out the not.

If IsNull([quotedate]) Then
Me.quotehow.Visible = True
Else
Me.quotehow.Visible = False
End If


Brian thought I was faster than you.

Michael

 

[Elvis]

Hi I've managed to get round this in the past by doing the following

DIM varMyDate as Variant

varMyDate = MyDate.value

If varMyDate <> Null Or varMyDate <> Empty Then

do something

Else

do something different

End If

Hope this helps

 

[Brianwarnock]

Michael
I think your 1st shot was what he wanted
Brian

 

[krberube]

Thanks for the fast reply all!
Using the isnull BEFORE the field did the trick. Just started using access with some VB and its amazing how much better your database can be!

This forum has been a great help.
Thanks again