Error 3071

  • Thread starter Thread starter Dana
  • Start date Start date
D

Dana

I have a report with a sub-report in it. When I preview
the report, all is well. The minute I try to print FROM
THE PREVIEW I receive the following error msg: 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)

The report prints out, but not the sub-report. If I skip
the preview and just directly print the report, it prints
fine - no error msg.

Please, please help!!!
 
This message sometimes indicates that Access is unable to match data types
somewhere. Typecasting calculated fields, or setting the Format property of
text boxes in the LinkMasterFields property of the subreport may help. More
info:
http://allenbrowne.com/ser-45.html

If that is not the case and you have code in the events of the report's
sections, is there anything that needs to be reset in the Report Header
section, so it is re-initialized after the preview and before the print?
 
Back
Top