Setting Default Date/Time field to be blank or null

D

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
 
F

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
Click to expand...

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.
 
L

Linq Adams via AccessMonster.com

The question that begs asking is "Who set the field's Default Value" to zero
in the first place? While Access automatically assigns a Default Value to
some datatypes in Table Design View (such as assigning zero to numeric
datatypes) it doesn't do this for Date/Time datatypes.
 
Top