Trim Function not working in Access 2000

[danly]

I imported a DB from 97 to 2000. Some of the reports were generated by the label wizard and use the Trim function.

When I run the report, Access does not recognize the Trim function, asking me to type it as if it's a parameter function, then returning #Error instead of data.

What gives?

Thanks,

Dan Lee

 

[Atomic Shrimp]

This sounds like a problem with a problem with a library reference; have a look at http://www.access-programmers.co.uk/ubb/Forum1/HTML/001834.html

HTH

Mike