Access 97 to XP and problems with the Format function

  • Thread starter Thread starter Al K
  • Start date Start date
A

Al K

I have an Access 97 application that I converted to Access XP for a client.
The application contains reports that use the Format function. For example,
an unbound text box could contain:

="Report Date: " & Format(Now(),"mm/dd/yy")

to display today's date on the report.

For some reason, the Format function in these reports is unrecognized as a
function and is being treated as if it were a parameter. When I run the
reports, a parameter box appears with 'Format' as the parameter text. Why
is Access XP doing this?

To make matters, more complicated, the reports run correctly on my machine
with Access XP, but not on my clients.

I know I could code around this, but I don't understand why the function is
not working.

Any help is appreciated.

Thanks.

Al
 
I solved my own problem. I needed to have a reference to the DAO 3.6 object
library.

Thanks.

Al
 
Back
Top