Format Function

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

Has anyone ever seen access 97 loose the format function.

I have a database that will not allow me to use the format
function. If I try to use it in a query, report, module
code or anything it treats it as if it doesn't exist.

For example in a report simply adding the date to the
bottom using the insert drop down menu witch adds a field
to the report to format the current date in your choice of
formats. If I do that the report comes up and asks for you
to enter Format as if it was an undefined variable that it
wanted you to enter.

Any ideas. It is only effecting this one database. If I
close this database and open another it works fine so it
isn't a problem with the actuall install of Access on the
machine.

Thank You
 
Justin,

This type of problem is commonly caused by 'lost references' to ancillary
libraries that Access uses.

At the database window open a Module or create a new one if you don't have
one. Then go to Tools > References and see if any are marked as missing. If
so, try to find it in the list and check the box to include it.

Gary Miller
 
"Sheridan 3D Controls" is listed as "MISSING:" I don't see
it listed further down in the list again. It is
referencing a file threed32.ocx which I do not have on my
computer at all, remember that the format command does
work in other databases on this same computer so I don't
think I'm missing a required file. Any ideas where to go
from here.

Thank you for your help.
 
References are like apples: one bad one can spoil the whole bunch. What's
happening is that the Format function is not actually part of Access: it's
contained in one of the references. Since Access doesn't know about the
Format function directly, it checks in the References to try and find it.
When one of the references is broken, it assumes there's a problem, even
though the Reference which contains the Format function is fine.

Uncheck the Sheridan 3D Controls if it's listed as MISSING:. To determine
whether or not you require it, compile your database (Debug | Compile All
Modules). If you need it, an error message should appear. If you don't, then
your database should now be fine.
 
Back
Top