Box labled "Enter Paramater Values?" Trim "What is it asking for?

[Pat]

When I click to view report everything is correct except for the line for the
city state and zip. This is the statement.

=Trim([City] & ", " & [State] & " " & [zip])

I can see nothing incorrect about the statement, but a box comes up asking
for something and the only hint is "trim"

 

[Duane Hookom]

This seems to be a references issue. Check Doug Steele's page
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

 

[Pat]

I am beginning to think my (65 yr old) mind is going. I have gone step by
step and still find no solution. I can run other reports (example an address
list) using the tables and it works perfectly. The report in which the error
occurs ran perfectly when it was originally created and nothing has changed.
Would you have any other suggestions?

This seems to be a references issue. Check Doug Steele's page
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

--
Duane Hookom
MS Access MVP

When I click to view report everything is correct except for the line for
the
city state and zip. This is the statement.

=Trim([City] & ", " & [State] & " " & [zip])

I can see nothing incorrect about the statement, but a box comes up asking
for something and the only hint is "trim"

 

[Duane Hookom]

Does your application compile? I assume you checked your references?

--
Duane Hookom
MS Access MVP

I am beginning to think my (65 yr old) mind is going. I have gone step by
step and still find no solution. I can run other reports (example an
address
list) using the tables and it works perfectly. The report in which the
error
occurs ran perfectly when it was originally created and nothing has
changed.
Would you have any other suggestions?

This seems to be a references issue. Check Doug Steele's page
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

--
Duane Hookom
MS Access MVP

When I click to view report everything is correct except for the line
for
the
city state and zip. This is the statement.

=Trim([City] & ", " & [State] & " " & [zip])

I can see nothing incorrect about the statement, but a box comes up
asking
for something and the only hint is "trim"

 

[BruceS]

Pat,

If <absolutely> nothing has changed (you're sure?), then the report could
have become corrupted. Try importing it into another database, deleting it
from the first one, then importing it back in from the second.

One other thought: You can't group, sort or filter on a calculated value in
a text box in a report, only on a bound field. Are you trying to do that
with your C/S/Z text box?

Bruce

I am beginning to think my (65 yr old) mind is going. I have gone step by
step and still find no solution. I can run other reports (example an address
list) using the tables and it works perfectly. The report in which the error
occurs ran perfectly when it was originally created and nothing has changed.
Would you have any other suggestions?

This seems to be a references issue. Check Doug Steele's page
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

--
Duane Hookom
MS Access MVP

When I click to view report everything is correct except for the line for
the
city state and zip. This is the statement.

=Trim([City] & ", " & [State] & " " & [zip])

I can see nothing incorrect about the statement, but a box comes up asking
for something and the only hint is "trim"

 

[Pat]

I just realized that I created this in 2000. I have not tried to compile it
or anything. I can not see a reason, but maybe the difference is that I am
now using 2003.

I guess the best thing is to simply redo the report rather than driving
myself nuts trying to figure what is wrong.

Pat,

If <absolutely> nothing has changed (you're sure?), then the report could
have become corrupted. Try importing it into another database, deleting it
from the first one, then importing it back in from the second.

One other thought: You can't group, sort or filter on a calculated value in
a text box in a report, only on a bound field. Are you trying to do that
with your C/S/Z text box?

Bruce

I am beginning to think my (65 yr old) mind is going. I have gone step by
step and still find no solution. I can run other reports (example an address
list) using the tables and it works perfectly. The report in which the error
occurs ran perfectly when it was originally created and nothing has changed.
Would you have any other suggestions?

This seems to be a references issue. Check Doug Steele's page
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

--
Duane Hookom
MS Access MVP

When I click to view report everything is correct except for the line for
the
city state and zip. This is the statement.

=Trim([City] & ", " & [State] & " " & [zip])

I can see nothing incorrect about the statement, but a box comes up asking
for something and the only hint is "trim"