Time reminders

[Vasya via AccessMonster.com]

How do I set up time reminders in my Access.
When the time comes close to the certain point, my record changes color or
something similar?

 

[Ofer]

I used that once, but we used it on a certain form.
you can set the time interval (and I can't remember the name of the other
proprty you need to set, if you interested I'll find out) on your form to
check the time every 1,2.... minutes, what ever you choose, so when the time
come the field will be colored.

if format(time(),"hh:mm")="23:36" then
me.myfield.backcolor=111111
endif