IsNull after a time period

[Guest]

Is there a way to change the value of a specific field to Null after a
certain period of loosing the focus.
Thanks in advance for your help.

 

[Dirk Goldgar]

Is there a way to change the value of a specific field to Null after a
certain period of loosing the focus.
Thanks in advance for your help.

Could you explain in more detail what you're after? It sounds an odd
thing to do. What it sounds like you want to do would probably involve
a Timer event on the form, as well as code in the control's GotFocus and
LostFocus events. But is seems very strange, and I'm not sure I
understood what you want.

 

[Guest]

Thanks for your reply Dirk.

Yes, it is odd. But I was asked to accomplish this and I explain further.
I have a web page updated by a MSAccess DB. It is Travel Business related.
One of the pages shows the Promotion field of the Database. I was asked that
after 15 days, the name disappears automatically from the page. The only way
that I can think of doing this, is to after 15 days of the time of
modification of the specified field it becomes null, programming further the
web page to show the row of the table only if the specified field is not
null. I hope I made sense.

Thanks again