Writing Event procedure to enter time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to enter the current time in a field when the label or field itself is
clicked.

There are 7 times to track in the table/form. Each time will be different
and I want to utilize the system time
 
I want to enter the current time in a field when the label or field itself is
clicked.

There are 7 times to track in the table/form. Each time will be different
and I want to utilize the system time
Click to expand...

Code the control's Click event:
Me![ControlName] = Time()

if you need the date and time then use = Now()

Format the control to the format you wish to display the time in.
 
My Friend,

I thank you. It works fine.

Have a great day.

fredg said:
I want to enter the current time in a field when the label or field itself is
clicked.

There are 7 times to track in the table/form. Each time will be different
and I want to utilize the system time
Click to expand...

Code the control's Click event:
Me![ControlName] = Time()

if you need the date and time then use = Now()

Format the control to the format you wish to display the time in.
Click to expand...
 
Back
Top