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?
 

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

Similar Threads

Error 3071 3
run-time error 3071 3
Subform not populating 5
Wildcards in IIF statements 3
Expression error 7
Access 97, DATE() Function not working 3
email report through module error but unknown where 2
Access Access Report Works on One Machine but not Another 3

Back
Top