I've used these, for years, on a series of apps that had to be 'full-screen,' and have never had any resource problems, but RG's advice is given by many experts. I suspect that with today's faster processors it's not as much of a problem as it used to be! But, as they say, your mileage may vary!
For your Textbox:
Code:
Private Sub Form_Open(Cancel As Integer)
'Displays while waiting for timer to crank up
Me.Auto_Time = Now
Me.TimerInterval = 5000
End Sub
Private Sub Form_Timer()
Me.Auto_Time = Now
End Sub
I really prefer doing this with a Label instead of a Textbox:
Code:
Private Sub Form_Open(Cancel As Integer)
'Displays while waiting for timer to crank up
Me.MyClock.Caption = Now
Me.TimerInterval = 5000
End Sub
Private Sub Form_Timer()
Me.MyClock.Caption = Now
End Sub
Also note that if you should start experiencing problems with 'screen-flicker' the Timer usage may be responsible!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007