error message

  • Thread starter Thread starter William
  • Start date Start date
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?
 
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
 
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?
Click to expand...
Click to expand...
 
Back
Top