Check box in report

  • Thread starter Thread starter Bisro Solan
  • Start date Start date
B

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?
 
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
 
set your approval field to invisible and add a check box:
set the source to =IIF(IsNull([approval]), 0, -1)
 
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

The query cannot be completed. 1
Only return top 5 records per category 1
Sum in Main Form from Subform 7
Query By Date and Count Records 3
Checkbox 2
Access Making a memo in Access 0
Criteria with check Box condition 3
check box with required fields 3

Back
Top