error: unknown function - "Format"

[smig]

I'm getting an error:
unknown function - "Format"

no missing refernces

any idea ?

 

[vbaInet]

VBA.Format()

 

[smig]

I never used VBA. for any function and it worked perfectly. also in this db.
but today I get this error

 

[vbaInet]

Something has gone wrong in your db. Best thing to do is to make a new db shell and import all your objects into that. Then set the references again, Debug > Compile.

 

[boblarson]

Also, make sure that you do not have your VBA project named Format. I just ran into that the other day with a user here who had named his VBA project FORMS and whenever he would try to use

Forms!FormnameHere

It would tell him that it needed to be a part of a collection.

So, just one more thing to check.