Error: Undefined function

[Maureen]

I have a query with a column that has the following:
mo: Format([datop],"mmm"). When I originally created
this query it all worked fine then one day I started
receiving this error message:
Undefined function 'format' in expression.
Does anyone know why this would start happening? And how
can i fix it?
Thanks!

 

[Peter R. Fletcher]

It sounds as if a Reference has been clobbered. Open a Module or Form
code in the VBA Editor and check Tools|References to make sure than
none of the ticked References are marked as Missing. If one is, untick
it and look further down the list for a Reference in the same "family"
(e.g. if MS Word 10.0 is missing and MS Word 9.0 is available, ticj
that. This sort of thing happens fairly reliably (!) if you do some
work on a database on a system that has Office XP and then move it
back to a system which has only Office 2000. The Word library
reference gets upgraded to 10.0 on the more up-to-date system but it
does not seem to automatically get "downgraded" when you move the
application back again.

I have a query with a column that has the following:
mo: Format([datop],"mmm"). When I originally created
this query it all worked fine then one day I started
receiving this error message:
Undefined function 'format' in expression.
Does anyone know why this would start happening? And how
can i fix it?
Thanks!

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher