If Date_Created is null then Date_Created = Date

How do I get this to work. I am using VBA in MS Access. I have a command button that when I click on it I want it to insert the date into a date filed I have on the form only if there is nothing in that field to begin with.

If Date_Created is null then
Date_Created = Date
End If

[290 byte] By [jasalandra] at [2007-12-16]
# 1


if IsNull(Date_Created) then
Date_Created = Date
End If


DMan1 at 2007-9-9 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 2
The above code is VB 6 use IsDbNull in .net
DMan1 at 2007-9-9 > top of Msdn Tech,Visual Basic,Visual Basic General...