By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,080 Members | 1,855 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,080 IT Pros & Developers. It's quick & easy.

CheckBoxes in Access Report

P: 2
Hello Everyone,

Im a new member in this GREAT forum.

My question is:
I have a simple database that contains many checkboxes and in the Report i want to show only the checked CheckBoxes for each record..

I followed some of the discussions in the forum but it didn't work..

Will you help me please??

Thank You..
Mar 4 '07 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,638
Hello Everyone,

Im a new member in this GREAT forum.

My question is:
I have a simple database that contains many checkboxes and in the Report i want to show only the checked CheckBoxes for each record..

I followed some of the discussions in the forum but it didn't work..

Will you help me please??

Thank You..
Let's assume you have a Check Box on your Report called chkFail. Placing this code in the Print() Event of the Detail Section will only display those chkFail Boxes that are actually checked while the others (not checked) will remain invisible. Hope this helped.
Expand|Select|Wrap|Line Numbers
  1. Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
  2. If Me![chkFail] Then
  3.     Me![chkFail].Visible = True
  4. Else
  5.     Me![chkFail].Visible = False
  6. End If
  7. End Sub
Mar 5 '07 #2

P: 2
Thaaaaaaaaaaaaaaaaaaaaaaanx it works perfectly....
Really really THANK YOU

Let's assume you have a Check Box on your Report called chkFail. Placing this code in the Print() Event of the Detail Section will only display those chkFail Boxes that are actually checked while the others (not checked) will remain invisible. Hope this helped.
Expand|Select|Wrap|Line Numbers
  1. Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
  2. If Me![chkFail] Then
  3.     Me![chkFail].Visible = True
  4. Else
  5.     Me![chkFail].Visible = False
  6. End If
  7. End Sub
Mar 8 '07 #3

ADezii
Expert 5K+
P: 8,638
Thaaaaaaaaaaaaaaaaaaaaaaanx it works perfectly....
Really really THANK YOU
Glad to have helped.
Mar 8 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.