Hi Folks:

I have created a form which contains checkboxes. The layout of the form is just the way I want the form to look on paper, when it is printed. Although I realize I should create a report to print the data input from the form, the report does not show the checkboxes. Instead, the report shows 0's and 1's where the checkboxes should be. I understand why this is, and am trying to figure out a way to just be able to print the form just the way it is ... except I don't want to print the command buttons on the form footer and I don't want to print the background unless I can get the background completely white. If I select 'print data only', it does not show my labels when it prints the data!! Please help.

If the check boxes on the form are bound to fields in an underlying table or query, you can simply create a report based on that table or query. Use the Report Wizard, and the result will probably be just fine. If not, go into Design view and manually change the text boxes with zeros and ones into check box controls.

In the report, delete the control that shows up as 0 or -1 and add a checkbox control to replace it. Set the checkbox control's datasource whatever the datasource was for the textbox you deleted.

Hope this makes sense
Charity