Calculated Control on Reports

  • Thread starter Thread starter chris1 via AccessMonster.com
  • Start date 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!
 
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.
 
You must log in or register to reply here.

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

calculate form control if one of them is blank 2
Access Access Report Works on One Machine but not Another 3
Access MSACCESS - Sorting report based on field calculated in the report 0
Struggling with Calculated Field on Form to Main Form/Table 2
Can't create a report from my query in Access 1
Rounding decimal values in forms and reports 2
Access 2010 Reports 0
Can I calculate from unbound text boxes? 1

Back
Top