Format Function not found in Access 2010 database

Question

I have an Access 2010 database that had many Format functions in both queries and VB code. It works fine.  I created a new Access database and now get a popup that says "Undefined function 'Format' in expression". I checked all my VB References, none are missing. I decompiled and recompiled the database and it finds all the Format Functions and gives an error.

I was doing some minor changes to the original, working Access database, the one where the Format Function was still working and, about half way through the editing I now get the same error.

The databases are on my computer only and are not web applications, they just created Excel spreadsheets for our team. Does anyone have any other suggestions as to what might be causing this issue.

Answer 1

I am not sure what you mean about it may say missing but may BE missing. None are missing. And I have decompiled and recompiled the database and I continue to get the same error.

Answer 2

Please post what Reference you have here....

Answer 3

Hine meant to type None, but missed the N key.  Ma note of the references you have and then try unchecking all the references and then rechecking each one.

Answer 4

one of the Reference may say missing but they may in fact BE missing.  What References are listed there?  (You can also have a look at  http://www.access-diva.com/d5.html)