Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Developer Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Report Check Box
David Popovich 
    
3 years ago
I'd like to use unbound check-boxes in a report that is used by a tech to indicate completion of a task on a list. However, there is no default value for a check-box in the report designer. In order to make the check-box blank, i have to write code in the on load event to set the check-box. One alternative is to start each content of the label string with a special character "open box". But, I can't seem to cut and paste this special character in the label. So, despite all the instructions to cut and paste special characters in a label, none of them work. Given there are in excess of 50 of these instances on the form, this is a task that should be easier to accomplish. Any suggestions would be appreciated.
Scott Axton  @Reply  
        
3 years ago
Just to make sure we're speaking apple to apples not apples to oranges here.
Reports are for printing what is in the table.  Forms are what you would use to enter / change the data.

So...   If the item is checked in the table.  It will print as checked in the Report.

You can set a default in the form for a check box.  Did I miss something?
Scott Axton  @Reply  
        
3 years ago
BTW - If there is an excess of 50 items to check off, I do NOT recommend having them in the same table.
You would actually want 3 tables.  CustomerT, JunctionT, and CheckItemT.  Then you would relate them using a Many-to-Many relationship.

This would allow you to delete or add items much easier in the future.
David Popovich OP  @Reply  
    
3 years ago
The checkboxes do NOT represent a field in the database. The report is really a "form" for a tech to check an item that will later be manually input into the database. Using a checkbox is simply a way of putting an item on the "form." Since checkboxes on a report, unlike checkboxes on a Access form, don't seem to have a property to preset the state. So, by default, the checkbox, when printed, is filled in with some fuzzy matrix of dots rather than empty. In order to make it clear, you have to set it to false. I did this in the OnLoad event to initialize. when you have 50+ of these, it's a chore to individually preset the state. In the old VB 6, you could create an array of checkboxes and the initialization woulf be a piece of cake. Access does not have this feature.
Kevin Robertson  @Reply  
          
3 years ago
Use a For Each Loop to loop through all the Check Boxes on your report to set each one to False.

Dim ctrl As Control
    
For Each ctrl In Me.Controls
    If ctrl.ControlType = acCheckBox Then
        ctrl = False
    End If
Next
Scott Axton  @Reply  
        
3 years ago
Thinking out side the box.
If this is just a way to print a report, what would be the drawback of setting up a dummy table - complete with the items you need - just for the report?   Then you could set the defaults to False and they wouldn't change.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/6/2026 5:13:02 PM. PLT: 0s