Report error - Trim

[Guest]

My label reports suddenly aren't working!
When I open them, the error message "Enter Parameter Value - Trim" appears.
When I press OK, my two lines that only have one field show up fine, but my
other two lines with multiple fields come up as errors - even though they
worked fine before!

I tried to correct this by writing my own VBA and came up with this:
Trim = [Title] & " " & [NameP] & " " & [NameL]
but there's an error for this too:
"Syntax error in query expression '[Trim = [Title] & " " & [NameP] & " " &
[NameL]]"

Even when I create new label reports with the wizard I get the same problem.

Please help!!!!

 

[Gina Whipp]

What did you have before? And where are you trying to remove leading
spaces? See below from chart in Help section...

Expression Description
=Trim(" A ") Removes all leading and trailing spaces, and returns "A".
=LTrim(" A ") Removes all leading spaces, and returns "A ".
=RTrim(" A ") Removes all trailing spaces, and returns " A".


Try: FullName: Trim([Title] & " " & [NameP] & " " & [NameL])

 

[Guest]

The trim command automatically came up because I used the label wizard.
There will be some leading spaces because not all contacts have a title, so
I guess that would be the second option.

What did you have before? And where are you trying to remove leading
spaces? See below from chart in Help section...

Expression Description
=Trim(" A ") Removes all leading and trailing spaces, and returns "A".
=LTrim(" A ") Removes all leading spaces, and returns "A ".
=RTrim(" A ") Removes all trailing spaces, and returns " A".


Try: FullName: Trim([Title] & " " & [NameP] & " " & [NameL])

My label reports suddenly aren't working!
When I open them, the error message "Enter Parameter Value - Trim"
appears.
When I press OK, my two lines that only have one field show up fine, but
my
other two lines with multiple fields come up as errors - even though they
worked fine before!

I tried to correct this by writing my own VBA and came up with this:
Trim = [Title] & " " & [NameP] & " " & [NameL]
but there's an error for this too:
"Syntax error in query expression '[Trim = [Title] & " " & [NameP] & " " &
[NameL]]"

Even when I create new label reports with the wizard I get the same
problem.

Please help!!!!

 

[JK]

Bill,

You cannot use Trim as variable name. The correct syntax is:

YourVar=Trim([Title] & " " & [NameP] & " " & [NameL])

Regards/JK

Kat - Did you ever figure this out? I just got the same problem from a
report I created in Access 2002 then tried to run from a PC running Access
2003... it errors with Trim looking for a parameter ( also, Mid in another
field is asking for a parameter). Thanks

My label reports suddenly aren't working!
When I open them, the error message "Enter Parameter Value - Trim"
appears.
When I press OK, my two lines that only have one field show up fine, but
my
other two lines with multiple fields come up as errors - even though they
worked fine before!

I tried to correct this by writing my own VBA and came up with this:
Trim = [Title] & " " & [NameP] & " " & [NameL]
but there's an error for this too:
"Syntax error in query expression '[Trim = [Title] & " " & [NameP] & " "
&
[NameL]]"

Even when I create new label reports with the wizard I get the same
problem.

Please help!!!!