Question Confusing error message

[jordatf]

I developed an application using Access 2007. One report does not work (so far) in Access 2010. When opened, the following message appears:
This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables. (Error 3071)

Possible causes:

• You typed an expression that has invalid syntax. For example, an operand or operator may be missing, you may have typed an invalid character or comma, or you may have typed text without enclosing it with quotation marks ( " ). Check the expression to make sure you typed it correctly.
• You typed an expression that is too complex. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning some parts to variables.

© 2010 Microsoft Corporation. All rights reserved.

I have looked at all the expressions and cannot find any errors. I have deleted the expressions and still get the message.

This is a report with a sub report. The main report data source is a self contained query that accesses two tables. The sub report uses an external query which accesses a table and another query.

Has anyone else encountered this?

 

[The_Doc_Man]

Places to look:

The report .RECORDSOURCE WHERE clauses if any

All cases of a computed control's .CONTROLSOURCE

Any FILTER (form/report) or CRITERIA (Domain Aggregate) clauses. In particular, domain aggregates have limited string sizes for their criteria clauses. Anything that could be truncated would do it.

This is not typically a VBA message, so I don't think it is module-based, but hey, I've been known to be wrong before. (On a fairly regular basis.)