current date error

  • Thread starter Thread starter Riffy
  • Start date Start date
R

Riffy

Hi,

Just a quick question that has got us confused. We are having problems
displaying the current date in a form, basically when trying to display the
current date in an unbound text box on a form the error #NAME? is shown
instead. This is only occurring in this database and only on forms, code
works fine. We have tried all the normal stuff like repair and recompiling
but to no avail!! Any ideas what is causing this and a solution would be
greatly appreciated

Thanks
Riffy
 
Did you include the equal sign and brackets in the text box's Control
Source:
=Date()

Does this work:
=Now()

Is there anything else that has the name date, e.g. a control, field, or
other object?

Any references marked "MISSING" under References on the Tools menu (from a
code window)?

Any other calculated fields on this form that could cause Access to barf
before it reaches this calculated control?
 
Hi Allen,

Thanks for the response. We did use the = sign, with both date() and now(),
neither worked. No references were listed as missing, and we also tested on
a totally blank form.... we have however overcome the problem in our own
way. We imported absolutely everything into a new database and it all seems
fine. We are none the wiser as to why this happened, looks like it could be
some form of corruption that we couldn't spot.

Thanks again for your time

Riffy
 
Back
Top