format() not working

[rex]

Hi,
My copy of access is not recognizing the format function.
In my code, I put this line...
report_date_string = Format(report_date, "m/d/yyyy")
Access responds with "Compile Error: Can't find project or
library". I just recently re-installed access and double
checked the references to make sure nothing was missing.
Every thing looks fine. Also the function left() is not
working for me. Other acces functions such as addDate()
however are working. What could be wrong?

Thanks,
Rex

 

[Van T. Dinh]

Still a Reference Error.

See Douglas J. Steele's article for more info:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html