Writing Event procedure to enter time

D

DonElston

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
 
F

fredg

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

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.
 
D

DonElston

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

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.
 

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

Top