print form without false checboxes

K

kim

Hi
Someone left the organisation and had set up a access database.
Data is entered with a form and the form is also printed off.
There are a lot of checkboxes on the form only a few of which are checked
in each record.
This results in wasted pages of blank checkboxes being printed.
The print action is triggered by a button with Do command (I think)
Is there a way to add code that would prevent unchecked boxes being added to
the printout? if so could someone give a code example?
Thank you
 
A

Arvin Meyer [MVP]

It can be done. Save your form as a report. Change the underlying data
source to a query which has columns that null all the false answers. Change
the report's check box controls to read the aliased columns.

OR

Redesign the database table to only enter a true value. Right now there must
be a column for each value. That's poor design (more like a spreadsheet than
a database) If the database is designed with a table of the values that are
true, you can select them from a combo or list box when they apply and never
use them when they don't. Now you get the desired result in your report, and
store the data efficiently as well.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top