=Dir(CurrentDb.Name) Not working in Report --> Control Source
Posted on 2013-05-23
Version -->: Access 2010
Dir(CurrentDb.Name) works in vba but does not work as a control Source in a Textbox on a report.
1) It's in the text box as --> =Dir(CurrentDb.Name)
2) It came over from Access 2003 where it was used all the time.
3) The database is an --> accdb
3) I don't know if this has anything to do with it, but I can't put DAO reference (Microsoft DAO 3.6 Oject Library) - It gives me an error -->Name conflicts with existing module, project, or object Library
Thanks in advance for any help.