Combine date and tim

K

kateri4482

I am trying to get a field on a form to show the current date and time when
it is clicked. I can get it where the current date gets shown OnClick (using
a macro), but how can I get it to show the date AND time? I am using the
"general date" in the table for the date field. So I guess I am asking how
to either change the macro so it allows date and time when I click on it (it
currently does a SetValue with the expression Date()), or how to write the
code so that it gives me the date and the time. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date search query 0
Recordset Findfirst Date Issue 0
Access 2007 Macro 1
Carry over date from previous record 1
Datepicker issue after changing Windows' short date time format 5
Using Date Parameters in a Query with Date and Time 7
I want access to fill a field with the current date 4
After Update Event 3

Top