labels

[Eric Comas]

I installed Microsoft 2000. I'm using access. When I do a
query and a create a label report using the label wizard
and then try to run the report I get a message box that
says"Enter Parameter Value" Then the word trim and a space
to enter some information. Why does this happen? It never
happened before in office 97? I don't know what to do .
Help!!

 

[Wayne Morgan]

The request for the parameter is coming up because you probably have a field name or
something mistyped. Since the word Trim is with it also, I'm guessing that you are
concatenating fields together into a single textbox or at least Trimming the fields you
are using to remove spaces. If this is the case, then the Control Source of the textbox
should look something like

=Trim([Field1] & " " & [Field2])

Check for typos.

In reports there are usually 4 places that a parameter can be prompted from, as mentioned
above, in the Group and Sort dialog box, in a Filter, in the Query feeding the report. A
typo in any of these locations could cause your problem. With the word Trim in there I
would suspect the textbox Control Source first then the query feeding the report.