Access 2003 parameter values and trim

[David Grant]

I want to produce mailing labels from Access 2003 by creating a new report.
No problem with this, but when I open the report a window appears named
'Parameter Values' and asks me to insert a Trim value. If I ignore this all
the lines on my labels show as #Error. Some other sites have suggested that
I open the file in design view, click on tools and then References, but
References does not show in the drop-down box when I click on Tools. Can
anyone provide a simple solution? Thanks

 

[Duane Hookom]

You must open any code module and then select Tools->References. This allows
you to find MISSING references and correct them.

 

[Jeff L]

It sounds to me like you have some wrong syntax somewhere. Trim is a
function in Access that removes trailing and leading spaces in a field.
If you have that in a field on the report, the syntax would be
=Trim(YourFieldName).

Hope that helps!