Date/Time: Does Now() Work in Access 2013? If Not, What Does?

[warrenpage]

I’m using Access 2013 and would like help creating a date/time field, please.



In my table, I am creating a field I am naming Timestamp. I want it to automatically enter the date and time.

The date and time should be whatever date/time it is when I start that record, or whenever I finish that record. Whatever Access chooses to use is acceptable to me, as long as it is entered automatically.
I'm not 100% sure how to do that. Let me tell you what I've done, which is clearly not correct.

When I design the table, I create a field named "Timestamp." I've selected Date/Time for the Data Type. I do not see an option for Auto Entry, so I'm not sure what to do. What I wound up doing is selecting General Date in the Field Properties' FORMAT area.

As I understand it, the General Date will display the date and time like this:
01/23/2013 12:35:25PM.

That's exactly how I want it. Unfortunately, it isn't working. After I enter fields into the table, I create a basic form using Create/Forms/Form. I don't even use the Form Wizard.

When I go into Form view, nothing is in the Timestamp field. So, the date and time are not auto-entered. There is an icon for a calendar to the right of the field, so I click it and select today's date. That is entered into the field. There is no time in there.

I did a Google search for this information, and found nothing specifically for Access 2013. I did find a web site for Access 2010.
http://databases.about.com/od/tutori...Timestamps.htm

It says to use the Now() option, which I tried. It didn't work. Access 2013 converted Now() to this: n\ow()

When I created the form, the Timestamp field had the following text inside it:
Oo5()

When I set focus to that field, it entered the date only, not the time.

So…what's the proper procedure to do this? I appreciate your help very much.
Warren Page

[June7]

The tutorial correctly instructs to use DefaultValue property, not Format.

[warrenpage]

Still not working. I made the change, and it is only displaying the date, not the time. So, how do I display the date and time?

[ItsMe]

Remove the formatting

[warrenpage]

I did. Still no time.

[June7]

Also, I think selection from the calendar only saves date part so you will have to fix those records.

DefaultValue only works for new record, not existing.

[warrenpage]

Okay, I think I know what went wrong. I had a few records that remained in the table before I made changes. After I deleted all of the records from the table, I created the form, and got the timestamp to work. Thanks for replying and helping.