Calculated Control on Reports

  • Thread starter chris1 via AccessMonster.com
  • Start date
C

chris1 via AccessMonster.com

I have a very quick question. I have a report based on a table and/or query
and I have created an unbound textbox that references fields from the
table/query.

Do the fields that are referenced in the calculated control (textbox) have to
be placed on the report as well?

I assume no because I tried it on a "dummy database" and the fields did not
have to be on the report in order for the calculated control to work but I
just wanted to be sure. Thank you!
 
K

Ken Snell \(MVP\)

The answer is -- sometimes yes, sometimes no. This can be an inconsistent
behavior in reports.

However, if you put an invisible textbox on the report that is bound to the
field, you ensure 100% of the time that you won't have a problem when
referring to the field in a calculated control. So, I recommend that you
always have a control on the report bound to every field that will be used
in expressions in control sources.
 
Top