I'm trying how to display the time so the seconds keep showing and the time changing.

Thanks

I use a timer to make this work
Set timer interval to 500 and enable it in the form load event

Private Sub Timer1_Timer()
Me.Caption = Format(Date, "Long Date") & " " & Format(Time(), "Long Time")
End Sub

Dunnie

Hi Dunie

i have just happened to search for my problem about how to display a clock on the Main menu in MS Access and come across this post.

Would you mind showing me more specifically how to do that? Where to set the interval and etc..

Many thanks:)

Create a text box on a form and call it txtClock
Set the format to Long Time

Go to the properties for the for and set the timer to 1000

use Code builder to set an event procedure under "On Timer"

Code should look like this:


Private Sub Form_Timer()

Me.txtClock.Requery

I would say that 500mS is a little slow. The update would only take place every ½ second.

When I do this, I always make the update 1/10 of a second or less. It just makes for a smoother-running clock...