TRIM command in reports not working properly

[postmanphat]

Hi...

I've created a mdb using access 2003. I have a report that produces address labels. I the parent table there are 3 fields that contain the seperate elements of a name 'Title', 'fname' and 'sname'.

The first row's control source on my label is:
=Trim([title] & " " & [fname] & " " & [sname]) resulting in for example 'Mr John Smith' Which works fine on my machine.

Now when I copy this db onto another machine with the same version of Access, when I go to run the report a parameter box comes up prompting me to enter a value for 'Trim'. If you hit ok or cancel I get a 'Name#' error.

Does anyone know why the Trim command behaves differently on different machines and how I resolve it???

Many many thanks in advance.

 

[Golom]

Sounds like you may have a missing reference. Go into a code module and click "Tools / References". Look for any references that are marked "MISSING".

 

[postmanphat]

Thanks... couldn't see a problem in my one and only code module. Copied all elements into a new db and it worked fine?!