error message

W

William

In a report in design view, there is a box in the Report Header with the
following in it:

="Base Allocation of $10,000 + Per Pupil Amount: " & [ImmPerPupil] & "
Funded at 29.84% of 15% or4.48%"

I want to remove the second line (beginning with "Funded"), but when I
delete and try to view the report, I get an error message that says:

The expression you entered has an invalid string.
A string can be up to 2048 characters long, including opening and closing
quotation marks.

I don't want that second line to appear in the report, but can't seem to get
rid of it without the error message popping up.

Ideas?
 
J

John Spencer

It is unclear what you want to eliminate. My best guess is

="Base Allocation of $10,000 + Per Pupil Amount: " & [ImmPerPupil]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
W

William

Perfect guess, John! Thanks, much.
--
William


John Spencer said:
It is unclear what you want to eliminate. My best guess is

="Base Allocation of $10,000 + Per Pupil Amount: " & [ImmPerPupil]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
In a report in design view, there is a box in the Report Header with the
following in it:

="Base Allocation of $10,000 + Per Pupil Amount: " & [ImmPerPupil] & "
Funded at 29.84% of 15% or4.48%"

I want to remove the second line (beginning with "Funded"), but when I
delete and try to view the report, I get an error message that says:

The expression you entered has an invalid string.
A string can be up to 2048 characters long, including opening and closing
quotation marks.

I don't want that second line to appear in the report, but can't seem to get
rid of it without the error message popping up.

Ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top