Check box in report

[Bisro Solan]

I have a query (qryAssyReport) that has fields for approvals (Culus, FM, Ce).
The approval fields have image numbers in them so my label software knows
what to image to print. What I would like to do is have check boxes on the
report (rptAssyReport) for all the approvals that will set themselves to true
or false based on whether the approval field is null. Can anyone help with
this?

 

[Arvin Meyer [MVP]]

Reports have static data and should not respond to data on them except to do
calculations. You can check the values in a report and do an update query
from VBA code.

If the check boxes are not bound to data, the can be checked or unchecked
based upon a value in another control.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley

 

[Maarkr]

set your approval field to invisible and add a check box:
set the source to =IIF(IsNull([approval]), 0, -1)