=Now()
=Date()
=Time()

now = date/time
date = date
time = time

On Feb 27, 7:35 am, clark32456 <clark32...@discussions.microsoft.com>
wrote:

Are you talking about ms-access here?

Normally, you use the forms before update event:

me.MyDateTimeField = now()

You can set the Default Value property of a table field to Time() to
get the current time (on December 30, 1899, the base of the date/time
system), or to Now() to get the current date and time, as of the
moment a new record is created.

You can also run an Update query updating a date/time field to Now();
or, using a Form, just type Ctrl-; (hold down the ctrl key and hit
semicolon) to fill in the time.

            John W. Vinson [MVP]