"#type!" error on report calculated field
You probably have a name clash, i.e. Access is picking up the Width
and Height
members of the report object rather than the fields called Width
and Height
.
I would create a new query and simply rename the problematic fields in it. So, if you're using the query designer:
- add the primary key and any other non-problematic field, then
WidthValue: Width
andHeightValue: Height
as additional columns; - finally, set the report's record source to be the query rather than the table directly, and update the calculated control formulae accordingly.
This is a pretty simplistic calculation. Any reason why you don't create a query, do the calculation in said query, and bind the report to the query instead? No sense killing yourself trying to figure this out.
In fact, now that I'm thinking about it, Height and Width are probably reserved words, as they're properties of a control. Maybe change them to HHeight and WWidth or something?