Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Default Date on Form Problem

Status
Not open for further replies.

jhays

Technical User
May 23, 2002
9
US
I have a field on one of an Access Form that I have the default value in the properties field set to today's date. I use =Date() to do this.
That has worked just fine for quite a while, but I must have changed something somewhere in the form or database because now instead of displaying today's date by default it displays #Name? in that field.
How can I get this to work again. I have notice that the =Now() works just fine, but the =Time() does not work either.

Thanks for the help
 
you may have lost the link to a Reference Library. Open a module (class or one behind a form) in design mode, click on Tools, then References.... look for any refence that has "Missing" associated with it, unclick the checkbox, and then reclick it.

PaulF
 
Paul,
Thanks for the help - that fixed it.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top