Parameter Problem

[fullofquestions]

I converted an existing database to Access2000. Now when I run a report that creates labels I get the parameter box with the word "trim" as the parameter to enter. No matter what you enter each lable is an error. Please help. TIA

 

[Eupher]

Do any controls on the report include the Trim() function? If so, please post an example of the expression. Or perhaps the query that the report is based on uses Trim()? Post the SQL, please.

Ken S.

 

[Walkinman17]

Mailing labels will likely use Trim()... each line would be a TextBox with a Control Source like:
=Trim([Firstname] & " " & [Lastname])

If you are missing the arguments -- the stuff in () --it would be treated as a Parameter...
walkinman17

 

[PHV]

Check the references:
In VBE (Alt+F11) menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[fullofquestions]

Thanks to each of you.
EUPHER: =Trim() is supplied by Access when you go through the Labels Wizard.
WALKINMAN17: the arguments are there nothing is missing.
PHV: The Reference highlited was:
Microsoft Visual Basic for Applications Exentsibility 5.3
Is this the correct reference?

TIA

 

[PHV]

You should have NO missing reference.
The code should compiles without error:
menu Debug -> Compile ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[fullofquestions]

PHV: I am creating a report from a query (that works) using the Label Wizard. When the report runs its asks me to enter a parameter for Trim.
The report appears to compile ok.
As far as reference goes...I do not know what references I am support to have so I would not know if any were missing.
Thank you for your help. What other suggestions do you have?

 

[fullofquestions]

HELP: Does anyone have a solution to this problem? TIA.

 

[fullofquestions]

For those of you that have helped I thank you.
PHV had the answer but could not explain it so that a novice (thats me) could understand what he was saying but thanks anyway.
The solution to this problem here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;283166