Setting date to Null

J

James

Hello,

I have a form that registers students and it sets a date one year from the
current date. However, if the user cancels for whatever reason, when it tries
to set it to Null or "" or " " it just sets it to 12:00:00 AM which shows
01/01/99 in the date field.

Is there anyway of setting a date field back to empty?

Any suggestions would be great

Many Thanks

James
 
S

Steve Schapel

James,

It is not clear what "when it tries to set it to Null" means. If you
are telking about using code, then this should work...
Me.MyDateField = Null
 
Top