if anyone has any ideas as to why the date function is returning null in my
access code i would greatly appreciate it. here is the code i have in my
access form:

Private Sub Form_Current()
If Due_Date_.Value < Date Then
Due_Date_.BackColor = vbRed
Due_Date_.BackColor = vbGreen
End If
End Sub

the date function works fine i all of my other office apps. just not here in
access where i could really use it.

thanks in advance
Glenn (Jreg)