I am basically Access illiterate but use it at work. I don't know strings or
other technical terms.

Is there a simple way to get a date field to automatically update to the
current date when new data is entered on a record? I don't want the date to
change if someone is just viewing the record.

Thanks,
Cathy

set the control's default to the following:

=Date()



--
Rick B



"Cathy" <(E-Mail Removed)> wrote in message
news:B5878DD4-3CE9-407B-A8BE-(E-Mail Removed)...
>I am basically Access illiterate but use it at work. I don't know strings
>or
> other technical terms.
>
> Is there a simple way to get a date field to automatically update to the
> current date when new data is entered on a record? I don't want the date
> to
> change if someone is just viewing the record.
>
> Thanks,
> Cathy

Hi Rick,

Do I do this in Objects-Tables or do I do this in the cell?

I don't see any control in Objects-Tables. In the cell, I see "control
source" and "Control Tip Text". Is it one of these?

"Rick B" wrote:

> set the control's default to the following:
>
> =Date()
>
>
>
> --
> Rick B
>
>
>
> "Cathy" <(E-Mail Removed)> wrote in message
> news:B5878DD4-3CE9-407B-A8BE-(E-Mail Removed)...
> >I am basically Access illiterate but use it at work. I don't know strings
> >or
> > other technical terms.
> >
> > Is there a simple way to get a date field to automatically update to the
> > current date when new data is entered on a record? I don't want the date
> > to
> > change if someone is just viewing the record.
> >
> > Thanks,
> > Cathy
>
>
>

Hi Rick and thanks for replying.

Where do I find the control's default? The only things I found in the cell
properties was "control source" and "controltip text".

Cathy

"Rick B" wrote:

> set the control's default to the following:
>
> =Date()
>
>
>
> --
> Rick B
>
>
>
> "Cathy" <(E-Mail Removed)> wrote in message
> news:B5878DD4-3CE9-407B-A8BE-(E-Mail Removed)...
> >I am basically Access illiterate but use it at work. I don't know strings
> >or
> > other technical terms.
> >
> > Is there a simple way to get a date field to automatically update to the
> > current date when new data is entered on a record? I don't want the date
> > to
> > change if someone is just viewing the record.
> >
> > Thanks,
> > Cathy
>
>
>

Hi Cathy,

In the design of the table for the date field:
1. Default value = Now()
2. Change the format of the same field accordingly as you might need.

Regards,
Vinayak

On Oct 12, 9:34 pm, Cathy <C...@discussions.microsoft.com> wrote:
> Hi Rick,
>
> Do I do this in Objects-Tables or do I do this in the cell?
>
> I don't see any control in Objects-Tables. In the cell, I see "control
> source" and "Control Tip Text". Is it one of these?
>
>
>
> "Rick B" wrote:
> > set the control's default to the following:
>
> > =Date()
>
> > --
> > Rick B
>
> > "Cathy" <C...@discussions.microsoft.com> wrote in message
> >news:B5878DD4-3CE9-407B-A8BE-(E-Mail Removed)...
> > >I am basically Access illiterate but use it at work. I don't know strings
> > >or
> > > other technical terms.
>
> > > Is there a simple way to get a date field to automatically update to the
> > > current date when new data is entered on a record? I don't want the date
> > > to
> > > change if someone is just viewing the record.
>
> > > Thanks,
> > > Cathy- Hide quoted text -- Show quoted text -