I have Reports in an Access DB that were created in Access 2003 and then converted to Access 2007. The trimfunction is not working. The same thing happens if I use the Label Wizzard to make a new set of address labels. Each time I try to run the report I get "Enter Parameter Value" box asking me to enter "Trim". I have followed all of the instructions in the help page "Why does Access want me to enter a parameter value?" under "Inspect expressions in a report". I have not found anything that is a problem.
There are four lines (fields) in the label. The control sources for the lines are
=Trim([First name] & " " & [Last name])
=Trim([City] & ", " & [St] & " " & [Zip])
Please advise what is happening here. How can I get "trim" to work?
Thanks in advance for your help.