Problem Formatting Date in Report

[swbrodie]

Okay, I'm about at my wit's end. I cannot, for the life of me, understand why this is not working properly.

Here's the problem...

I have a report that displays a header at the top of the page. This header takes the values (StartDate and EndDate) passed from a form, formats them as mmmm dd, yyyy, and prints them in the header, within a text box.

Here is the code...

=Format([Forms]![ReportCriteria]![StartDate],"mmmm dd"", ""yyyy") & " to " & Format([Forms]![ReportCriteria]![EndDate],"mmmm dd"", ""yyyy")

This code works perfectly on my system which is running Access 2002, but when I open the report on a system that is running Access 2000, the Enter Parameter Value message pops up and asks me to enter a value for Format. This makes no sense. It seems as if it thinks that Format() is a field, not a function.

I know the Format() function is available in Access 2000 and I'm sure the syntax is the same. I have tried simplifying the expression to something like =Format(Now(), "mmm"). I have tried rebuilding the report. I have tried creating a new form and creating a single text box to test on. Still nothing works. If I remove this header line and rerun the report, it comes up properly, so I know this code is the problem. I just don't know why.

Am I missing something totally obvious? I'm starting to feel really stupid about now. Oh, yeah, and it was working fine before.

Please help.

 

[pdx_man]

Search the forums here for Missing Reference.

 

[swbrodie]

Thank you very much.

There was a reference to fpdtc.dll, which is available in Access XP, not 2000. I removed the reference to this library and everything is working now.

Now I can go to lunch.