Setting Default Date/Time field to be blank or null

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

On Mon, 14 Apr 2008 15:12:00 -0700, Dj wrote:

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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com