Setting Default Date/Time field to be blank or null

[Dj]

I have a date/time field in my record that I plan to use to indicate when a
record was modified. If the record was never modified, I'd like that field
to be blank. It seems to want to default to 0 which is giving me a bogus
time of 12:00. All my records are originally imported in weekly so seldom
are records manually added. I don't know if that makes a difference or not.
If this is something that can't be done, I guess I can make the default NOW()
but I was really hoping for a blank. Thanks in advance, dozzee

 

[fredg]

I have a date/time field in my record that I plan to use to indicate when a
record was modified. If the record was never modified, I'd like that field
to be blank. It seems to want to default to 0 which is giving me a bogus
time of 12:00. All my records are originally imported in weekly so seldom
are records manually added. I don't know if that makes a difference or not.
If this is something that can't be done, I guess I can make the default NOW()
but I was really hoping for a blank. Thanks in advance, dozzee

If it's defaulting to 0, then open the underlying table in Table
Design View.
Find the date field in question. Delete the 0 from the DefaultValue
property.
Save the change.
Open the form in Design View.
Select the Date control. Delete the 0 from the DefaultValue property.
Save the change.