Re: Error Message when running report

Hi Jennifer,

Expr1 is what Access will assign for the first calculated field in a recordset... I suspect that

Ex[r

needs to change to Expr

You either have a bad reference in your code, a calculated field in the report, or the query that the report is based on.

I would check the query first -- look at the calculated fields. You can, by the way, change Expr1 to be something more logical... anything before the colon in a query will be the fieldname that the report uses. Avoid spaces and special characters (except underscore) in names.

To check your code:

go to the design view of any module:

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code or references, your should always compile before executing.

from the menu in a module window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)

'~~~~

if you didn't find it yet, we can give you more things to check

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Jennifer Nadey wrote:
I have a report, which runs off a query, which runs off a table. I added a
column of data to the table and then that column to the query. I went into
the report via Design View and added a text box to display the value of the
new column. When I try to run the report, I get the following error
message:

"The expression On Format you entered as the event property setting produced
the following error: The object doesn't contain the Automation object
'<<Ex[r>>.'.
* The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro."

Any thoughts on how I can fix this error?

Thanks,
Jennifer




.

Relevant Pages

  • Re: Error Message when running report
    ... did you Compile your code? ... did you change the ControlSource and Name properties on the report to match the columnname in your query? ... You either have a bad reference in your code, a calculated field in the ...
    (microsoft.public.access.reports)
  • Re: Error Message when running report
    ... Sorry there was a typo in my re-typing of the error message. ... The query runs and provides the correct data with no ... report, or the query that the report is based on. ... Whenever you change code or references, your should always compile ...
    (microsoft.public.access.reports)
  • Re: String Used in Report Displays as Garbage
    ... All the text in the calculated fields in my query are left aligned. ... I tried creating a new report with only the calculated field printed. ... You say the calculation looks fine in the query. ...
    (microsoft.public.access.reports)
  • Re: Amount claimed Sub total
    ... If your referring to the calculated field in the query, ... let's handle the query behind the report. ... will yield the totals for each category. ...
    (microsoft.public.access.reports)
  • Re: Amount claimed Sub total
    ... If your referring to the calculated field in the query, ... let's handle the query behind the report. ... will yield the totals for each category. ...
    (microsoft.public.access.reports)