Check box in report

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?

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


"Bisro Solan" wrote in message
...
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?

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

"Bisro Solan" wrote:

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?