display current date and time continuously in form entry

G

Guest

I want the current date and time displayed continuously during data entry on
form in access database
 
A

Al Campagna

Alex,
In the form properties, set the timer interval to 60000 (will trigger
every 60 seconds)
Format an unbound text control (ex. MyDateTime) for...
m/dd/yy @ hh:nn
Create an OnTimer Event Procedure...
Private Sub Form_Timer()
MyDateTime = Now
End Sub
 

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

Hello happy new year to all, Text box input for year of purchase 0
Date Picker Default? 1
Date last filled... 18
Forcing a date entry format of dd/mm/yyyy 1
CALCULATED VALUES FROM CURRENT VALUES IN AN ENTRY FORM 2
time entry restriction 3
Excel Concatenate Form Name to Parse for function 1
Date validation in subform textbox dependent upon form textbox 1

Top