I have an unbound date field in a form (short date). Sometimes, the date in
the form is Empty / Null. When I save to the underlying table, my date
variable is set to 12:00:00 instead of null or empty. The forms field
evaluates to null. The recorded date in the underlying table is saved as
12/30/1899.

1. Why is this?
2. How can I save "nothing" in the date field of the table?

Thanks

Ross

Ross

Check the table definition ... that date/time field probably has a default
value of 0 (which translates in Access date/time parlance to 12/30/1899 @
12:00).

--
Regards

Jeff Boyce
<Office/Access MVP>

"Ross" <(E-Mail Removed)> wrote in message
news:04E2A246-4156-422A-8C91-(E-Mail Removed)...
> I have an unbound date field in a form (short date). Sometimes, the date
in
> the form is Empty / Null. When I save to the underlying table, my date
> variable is set to 12:00:00 instead of null or empty. The forms field
> evaluates to null. The recorded date in the underlying table is saved as
> 12/30/1899.
>
> 1. Why is this?
> 2. How can I save "nothing" in the date field of the table?
>
> Thanks
>
> Ross

Jeff,

There are no defailts set and the record is "pre-existing" (Not a new record).

"Jeff Boyce" wrote:

> Ross
>
> Check the table definition ... that date/time field probably has a default
> value of 0 (which translates in Access date/time parlance to 12/30/1899 @
> 12:00).
>
> --
> Regards
>
> Jeff Boyce
> <Office/Access MVP>
>
> "Ross" <(E-Mail Removed)> wrote in message
> news:04E2A246-4156-422A-8C91-(E-Mail Removed)...
> > I have an unbound date field in a form (short date). Sometimes, the date
> in
> > the form is Empty / Null. When I save to the underlying table, my date
> > variable is set to 12:00:00 instead of null or empty. The forms field
> > evaluates to null. The recorded date in the underlying table is saved as
> > 12/30/1899.
> >
> > 1. Why is this?
> > 2. How can I save "nothing" in the date field of the table?
> >
> > Thanks
> >
> > Ross
>
>

Ross

A value of "0" translates to the date/time you mentioned. Somehow a zero
ended up in there.

Did you check the default on the form, or in the table definition?

--
Regards

Jeff Boyce
<Office/Access MVP>

"Ross" <(E-Mail Removed)> wrote in message
news:45F391A1-DB50-4984-8145-(E-Mail Removed)...
> Jeff,
>
> There are no defailts set and the record is "pre-existing" (Not a new
record).
>
> "Jeff Boyce" wrote:
>
> > Ross
> >
> > Check the table definition ... that date/time field probably has a
default
> > value of 0 (which translates in Access date/time parlance to 12/30/1899
@
> > 12:00).
> >
> > --
> > Regards
> >
> > Jeff Boyce
> > <Office/Access MVP>
> >
> > "Ross" <(E-Mail Removed)> wrote in message
> > news:04E2A246-4156-422A-8C91-(E-Mail Removed)...
> > > I have an unbound date field in a form (short date). Sometimes, the
date
> > in
> > > the form is Empty / Null. When I save to the underlying table, my
date
> > > variable is set to 12:00:00 instead of null or empty. The forms field
> > > evaluates to null. The recorded date in the underlying table is saved
as
> > > 12/30/1899.
> > >
> > > 1. Why is this?
> > > 2. How can I save "nothing" in the date field of the table?
> > >
> > > Thanks
> > >
> > > Ross
> >
> >