Medium Time in unbound text box

[mainerain]

I am trying to have the time display on a form. I have done this in another db that worked fine. I duplicated the same scenario and attributes (that I can tell) but it won't work on new db. I am beside myself. I figured it out once before but I am stuck now. Any suggestions? Thanks.

[Welshgasman]

Copy the control from the db where you say it works?

[CJ_London]

perhaps your control needs a controlsource of '=time()' and formatted as medium time. If it is any more complicated than that you need to tell us an awful lot more

[moke123]

what time? Time from a field in a table or the current time?

Have you tried the Time()?

?format(time(),"medium time")

[mainerain]

perhaps your control needs a controlsource of '=time()' and formatted as medium time. If it is any more complicated than that you need to tell us an awful lot more

That does show a time but it doesn't continue to update.

I came back after a long break and found what I had done. Under the form Event tab I set the time interval to 1000 and the On Timer event I referenced the name of the text box like this: tbxTime = Now

[CJ_London]

so you wanted the current time to display in an unbound control?

by why update every second when you are only displaying hours and minutes?

suggest include a bit of code in your timer event to reset the interval to 60000 when number of seconds=0

Private Sub Form_Timer()


    TxtTime = Now()
    If Second(Now()) = 0 Then TimerInterval = 60000

End Sub

[mainerain]

I don't fully understand how the On Timer and Time Interval work. I get the same result either way. Is your way better in some way? I tried putting the 60000 in place of my 1000 for the Time Interval and with just tbxTime = now in vba but it didn't work. Any explanation is appreciated. Thanks.

[CJ_London]

the code I provided works for me - just need to put the name of your control

timer events cause other code to pause whilst it runs - it may be you are not running other code which would be affected by this, but once a minute is better than 60 times a minute