format function no longer available in querys

[Guest_imported]

I have a form based on a query that uses format in design grid. In the last couple of days form no longer works,


Error message is "Fucntion isn't available in expressions in query expressions 'Format(APP_DATE, "mmmm dd yyyy&quot'"

All format expressions in querys no longer work. I have reinstalled access97, Any suggestions?

Thanks
David

 

[RichUK]

Look for missing references.

 

[JoaoTL]

Hi, see this article

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q194374

Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt

 

[JoaoTL]

SORRY above that link is broken, see this one

http://support.microsoft.com/support/kb/articles/Q194/3/74.ASP

Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt