Date() vs. Now() (Access97)

[DavidHorning]

I have a database in place with a half dozen different users in remote locations. They all use Access97. In a number of forms =Date() is used to provide today's date as the default value. At two of the sites, this worked fine initially. However, at some point something changed. Instead of seeing today's date when the form opened, there was an error message in the date field. #number or something like that. As soon as you click into that field the proper date come up, but it was very distracting to the users. At the other sites it still works fine. The only work around I've been able to come up with is to use =Now() instead. It works fine. But that requires the extra step for changing the format on all uses of that entry to ShortDate to get rid of the time. Anyone ever see this happen? Got any thoughts as to why? Thanks, Dave.

[HansV]

The first thing to check in such circumstances is invalid references.

Open any module (it may be an empty new one).
Select Tools/References...
Uncheck all references (if any) saying MISSING.
Click OK.

If the problem goes away, fine. Otherwise, post back.

[DavidHorning]

Thanks for the prompt reply. I will be a few days before I'm able to access this remote site and try the solution. I do wonder, however, since we are only going after date, would a missing reference do this? Also, since as soon as you click the field, then the date correctly displays. That's probably the one thing that throws me the most. Add to that the fact that it did work in the first several months of usage.

[patt]

You may have a corrupt form at this remote site. Try creating a new form and copy all the controls to the new form except the control in question and see what happens. Databases can corrupt.
Could someone have fiddled with it?
Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

[DavidHorning]

Databases being used at remote sites by novices. What ever in the world makes you think someone might have fiddled with it. lol.

Thanks for the reply.