Trim function not working

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([Street 1])

=Trim([Street 2])

=Trim([City] & ", " & [St] & " " & [Zip])

Please advise what is happening here.   How can I get "trim" to work?

Thanks in advance for your help.

 

Question Info


Last updated October 11, 2019 Views 8,523 Applies to:

Press Alt+F11 to activate the Visual Basic Editor.

Select Tools | References...

You will see a list of references, the first few of which have their check boxes ticked.

Clear the check box for all references whose names begin with MISSING.

Does that remove the problem?

---
Kind regards, HansV
www.eileenslounge.com

27 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Note also that Trim() merely removes leading and trailing blanks from a text string, and that these fields ordinarily would nothave any leading or trailing blanks; try just removing the Trim() function from around the expressions.
John W. Vinson/MVP
John W. Vinson/MVP

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Thank you HansV! This solved my exact problem when moving an Access 2000 Database to Access 2010.

With help also from an article at http://allenbrowne.com/ser-38.html I understood that the MISSING: utility.mda file it was looking for was in a folder on my old computer was probably useless to Access 2010 and yet the reference to it must have been causing  the trouble. I suppose just moving it down the priority list might have worked as well.

So, unchecking it as you suggested solved my problem (same as emnh's problem) and another problem too.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Glad it helped!
---
Kind regards, HansV
www.eileenslounge.com

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I suppose just moving it down the priority list might have worked as well.

 

Actually it wouldn't; if ANY reference in the list is MISSING, you will get errors and unrecognized functions, even if they are calls to libraries which aren't missing.

 

John W. Vinson/MVP

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

HansV, I am slow in responding.  Your suggestion did work.  Thank you!

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Thanks for the help HansV. I just wanted to reply was still helpful in Access 2016.

4 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.