updating system time on a form

  • Thread starter Thread starter Bob Betts
  • Start date Start date
B

Bob Betts

Hi .. I inserted a text box and typed following command =Now() .... It
displayed the date and time but it isn't being updated automatically ...
what do i do so that the time changes or updates on screen on its own while
the form is open.

Thanks.
 
Bob Betts said:
Hi .. I inserted a text box and typed following command =Now() .... It
displayed the date and time but it isn't being updated automatically ...
what do i do so that the time changes or updates on screen on its own
while the form is open.

Thanks.
Click to expand...

Enable the Timer propery of the Form (in which a unit is approximately one
millisecond) and in the Timer event update the time.

Larry Linson
Microsoft Access MVP
 
Thanks larry .. how is this done .... do I put a 1 value in the timer .....
how do i use the timer event?

Tha nks .
 
I set the time interval to 1000 and placed a docmd.requery on the on timer
event and nothing happens .... i tried to put a docmd.beep and i could hear
the computer beep every second but it does not refresh the time .... it only
does every time I push F9 button to refresh .....
 
Thanks .. its now working ... i made it unbound instead of putting an @now()
..... thanks for those who responded
 
in message:
Thanks .. its now working ... I made it unbound instead of putting an @now()
.... thanks for those who responded
Click to expand...

You're welcome, glad we could help.
Good luck with your project.
 
Back
Top