Trim function parameter

[Guest]

I converted to Office 2007 from 2003. I have labels that were created in
2003.. When I run the "report - labels" it asks for the "enter parmeter trim"
-trim- Inlabels it follwoing is created =trim([address1]) - Similar for
several lines.

I can't fin how to correct the problem, and I revreated the labels in 2007,
and I still get the same request message when I run the report - labels-

Can anyone help.
Thanks,
Dick

 

[fredg]

I converted to Office 2007 from 2003. I have labels that were created in
2003.. When I run the "report - labels" it asks for the "enter parmeter trim"
-trim- Inlabels it follwoing is created =trim([address1]) - Similar for
several lines.

I can't fin how to correct the problem, and I revreated the labels in 2007,
and I still get the same request message when I run the report - labels-

Can anyone help.
Thanks,
Dick

That PC has a missing reference.
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

For even more information, see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[Guest]

Fred, I spent hous lookin for the answer, claring the "missing" corrected the
problem. Question, I went back to again look at the list, "missing" is
missing.

does that only show up when there is a proble?
Thank you for your help..

Dick

I converted to Office 2007 from 2003. I have labels that were created in
2003.. When I run the "report - labels" it asks for the "enter parmeter trim"
-trim- Inlabels it follwoing is created =trim([address1]) - Similar for
several lines.

I can't fin how to correct the problem, and I revreated the labels in 2007,
and I still get the same request message when I run the report - labels-

Can anyone help.
Thanks,
Dick

That PC has a missing reference.
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

For even more information, see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[fredg]

Fred, I spent hous lookin for the answer, claring the "missing" corrected the
problem. Question, I went back to again look at the list, "missing" is
missing.

does that only show up when there is a proble?
Thank you for your help..

Dick

I converted to Office 2007 from 2003. I have labels that were created in
2003.. When I run the "report - labels" it asks for the "enter parmeter trim"
-trim- Inlabels it follwoing is created =trim([address1]) - Similar for
several lines.

I can't fin how to correct the problem, and I revreated the labels in 2007,
and I still get the same request message when I run the report - labels-

Can anyone help.
Thanks,
Dick

That PC has a missing reference.
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

For even more information, see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

If it's not listed as Missing then you're OK.