Dates - Automatic Entry

N

Novice

I'm not sure how to phrase this question exactly. I would like to change the
date field in one of my tables so that when I put the date field on my form
it will automatically fill in the current date instead of manually entering
it.

Thank you.
 
J

Jerry Whittle

It's called a default value. Open up the table in design view. Click on your
date field. Down towards the bottom in Default Value put:

=Date()

It's important to put it in just like above. Now every new record will have
the computer's date added to the date field. I said "computer's date" as I
have seen some PCs days, weeks, even years off.

If you use =Now() that will put in both the date and the time.
 
Top