Refresh now()

  • Thread starter Thread starter Eduardo Sanchez
  • Start date Start date
E

Eduardo Sanchez

Hi,
I am using now() function on a form on a date and time
field to improve consistency. However, it appears that now
() only refreshes when you close and open the database. I
fiddled with refresh intervals in tools, options, advance.
It did not help,
Any Ideas? Thanks
Eduardo
 
Now() returns the value of DateTime *when the function is executed*.
The Refresh Intervals Property is about refreshing data, not the value of a
function.

Clearly you want to re-execute Now() at appropriate time but we don't know
your use.

Explain your relevant Table and Form set-up in relation to the Now()
function and I am sure someone will come up with an answer for you.
 
Back
Top