Is it possible to automate the '=Now()' function so that the correct time is
always displayed on a form?

tia
--
Jock Waddington

Jock W:

Not sure you could do this without instituting a timer function, of some
sort, and have it trigger every 15 seconds, or so.

Or you could code to update the time after every event. Aside from the
workload to do this, if someone left their desktop idle, the time wouldn't
update.

Good luck.

Sharkbyte



"Jock W" wrote:

> Is it possible to automate the '=Now()' function so that the correct time is
> always displayed on a form?
>
> tia
> --
> Jock Waddington

Set a field on your form [TodayDateTime]
On the Open Form event
Me.[TodayDateTime] = Now()
Then On Timer event; same thing
Me.[TodayDateTime] = Now()
set the "Timer Interval" to 1000 updates every second