Click button enter current time

  • Thread starter Thread starter Teddy
  • Start date Start date
T

Teddy

I am creating a form using Access 2003. One field on my form is Start. I
would like to add a button next to this field so that when I click the button
on the Form the current time will display in the field.

Can you tell me what I need to do to the Start field in the table and the
form where it exists in order to make this work?
 
Teddy said:
I am creating a form using Access 2003. One field on my form is Start. I
would like to add a button next to this field so that when I click the
button on the Form the current time will display in the field.

Can you tell me what I need to do to the Start field in the table and the
form where it exists in order to make this work?
Click to expand...

In the code for the button's Click event...

Me!Start = Now()

You don't need to do anything to the table.
 
This is awesome. Thank you for your help. When I use the code I get this
data “11/26/2009 9:55:30 PM†do you know how I can shorten it so that it
will only display the time such as 9:55 pm. I changed the format to medium
time on the table in design view but that didn’t seem to make a difference.
Any input is greatly appreciated thank you again for your help.
 
Back
Top