Trim Value

[zephyr34]

Hi,
I am trying to open a report up in Access 2002 AKA Office XP Access.. But I keep getting a message box that says 'Parameter Undefined' 'Enter Trim Value' and anything I enter returns a blank report with nothing on it..
The report has data and should be working and was working up until I started getting this message.. Anyone seen this or know why??
INPUT!

 

[scriverb]

Sounds like your underlying query that supplies the records for the report has a problem. I would go to the query and try to run it alone and see if you still get the message. It sounds like you have a Trim statement that has become corrupted or something.

If that is not it get back with me and we can look further. Bob Scriver

 

[zephyr34]

This Database was in Access 97 and still works fine in Access 97..
But when I converted it to 2002 Access it started giving me this Trim Value message..

 

[scriverb]

You are using different Libraries in 2002 so I would suggest that you check your References and see if any of the checked references to dll's show as Missing. It sounds like 2002 doesn't know what a Trim Function means. You must be using that Function somewhere in your query or report.

Let me know. Bob Scriver