Access 2007 TRIM

[Guest]

I am using a database that was developed in Access 2003 and when I try to
print a set of labels, it asks me for the parameter "TRIM" as if I wanted to
input a variable value. I went back to Access 2003 and the database still
works properly and prints out the labels.
I then made up a sample label in Access 2007 using the TRIM function with
the same result. When I tried to run the label; it asked for the
"paramenter" TRIM's value.
Have they changed something or am I missing something? I can use the
function when writing the report but it doesn't recognize the function when I
run the report.

 

[Allen Browne]

Suggestions:

1. Add the folder where you keep your database as a trusted location under:
Office Button | Access Options | Trust Center | Trust Center Settings

2. Open any code window (e.g. press Ctrl+G), and choose References on the
Tools menu. Make sure none of the checked libraries have the word "MISSING"
next to them. If you find this problem, see:
http://allenbrowne.com/ser-38.html