Aslways show Current Date even in Old records

[Manny]

I am using =Now() to show current date ina Access filed. But I want to
be able to see current date in same field even when I look at OLD
records- Now If tomorrow I look at today's entered record itshows date
was entered now date I am currently looking at the record. Need
Something like current clock- ....thanks.........

 

[Rick B]

If you want to show the current time, then don't store it in the record.

Just add an unbound text box to your form with the following in it...

=Now()

 

[Manny]

You are right, but I need this field to calculate lapsed time (passed
due in days ) at anytime I go to that record,
It is like updating the a form everytime I look at it but with current
date.

 

[Guest]

Heck, I'm having a slow afternoon, so I'll take a shot at this.

Seems to me, then, that you need to save the initial date, which you are
doing. THEN, you need a second unbound field/control that does a DateDiff
calculation between the initial date and Now(), and displays the result.

If you set it up that way, the initial date will stay the same forever
(unless you edit it), but each time you open the record again the system will
calculate and display how many days it has been since that initial date.