=Date() expression. URGENT RESPONSE NEEDED PLEASE

[jk12]

Hi all. Within my report i have an unbound text field with its control source set as =Date(). However when the report is opened, the following error appears, #Name?. This error only happens when the database is opened using Access 2000. It is fine however when opened using Access 2003. The file though is saved as a 2000 format and was created using 2000 and worked in 2000 up until a week ago.

Any ideas as to what has happened?

 

[KenHigg]

Maybe you can set this in the default value instead of the control source?

 

[jk12]

well like i said it has always been set in the control source and worked fine until a week ago and still works fine when opening from access 2003. it just doesn't work when opening from 2000

 

[jk12]

also i can't see the default value option for a unbound text box in the properties pop up. where is it?

 

[Rich]

You have a missing reference
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[jk12]

yeah that seems to be exactly the problem. sorted now thanks for that