String Too Long

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

When I click on the Record Source of a report, I have the following statement as part of
my Criteria:

Is Not Null And IIf([Forms]![boxDate]![PrintOneOrAll]=1,IIf(Format([BillDate],"mm\,yyyy")
=Format(Now(),"mm\,yyyy"),[BillDate]))

This is repeated in a similar fasion three more times (for different values of [PrintOneOrAll],
and the code works fine.

Now if I want to add more statements to the criteria (six in total) and then try to save my
work, I get the following "Information" message:

"The string returned by the builder was too long.
The result will be truncated."

My questions:
What (if anything) am I doing in a way that is not proper?
What is causing this problem?
How does one code this differently to avoid the problem?
Would you do this kind of thing in a different way?

Thanks for you help,
Bernie
 
Have you considered creating one/more queries that generate the same result?
Then using the query(ies) as the source for the report?
 
Back
Top