Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Show check boxes on a report that are true.
- Thread starter Syerston
- Start date
John,
On the tool bar in Reports, click on the check box and insert it into the report. Leave or delete the label (whatever your preference is). Right click and go to properties and go to control source and select the field you want the check box to correspond to. When the value is True, a check box will appear. I hope this answers your question.
Mike
On the tool bar in Reports, click on the check box and insert it into the report. Leave or delete the label (whatever your preference is). Right click and go to properties and go to control source and select the field you want the check box to correspond to. When the value is True, a check box will appear. I hope this answers your question.
Mike
- Thread starter
- #3
Mike
I'm sorry its not as simplistic as that I should have been more descriptive.
I only want to list the boxes that have a true value. So instead of printing a possible 16 I only want the report to show for example the two boxes that are ticked. John
I'm sorry its not as simplistic as that I should have been more descriptive.
I only want to list the boxes that have a true value. So instead of printing a possible 16 I only want the report to show for example the two boxes that are ticked. John
Go into the query behind the report. For the criteria for the checkbox, type in Yes. That way, the report will only show records that are true.
Linda Adams
Visit my web site for writing and Microsoft Word tips: Official web site for actor David Hedison:
Linda Adams
Visit my web site for writing and Microsoft Word tips: Official web site for actor David Hedison:
- Thread starter
- #5
That is the way the query is designed.
In order for the records to be brought back the query checks if the first check box is true or the second check box is true and so on. The problem is that each record will come back with, for example 12 false check boxes and 3 true check boxes, or at the very least one box set to true.
What I want on the report is a list for each record of the check boxes set to true. John
In order for the records to be brought back the query checks if the first check box is true or the second check box is true and so on. The problem is that each record will come back with, for example 12 false check boxes and 3 true check boxes, or at the very least one box set to true.
What I want on the report is a list for each record of the check boxes set to true. John
Hi, Since this is in a report, you might consider handling the problem in a slightly different way - worked for me at any rate.
I created a set of labels that looked like a check box using paintshop pro. I needed different colors as well. I imported the checkboxes into the report detail section. I set the real check boxes to invisible and the checkbox labels invisible.
For each checkbox I had a select case statement (you can use IF as well) and had something like the following:
Select Case me!ckbox1
Case is = -1 'if value is true - label is visible
me.lbl1.visible = True
End select
Hope that helps.
I created a set of labels that looked like a check box using paintshop pro. I needed different colors as well. I imported the checkboxes into the report detail section. I set the real check boxes to invisible and the checkbox labels invisible.
For each checkbox I had a select case statement (you can use IF as well) and had something like the following:
Select Case me!ckbox1
Case is = -1 'if value is true - label is visible
me.lbl1.visible = True
End select
Hope that helps.
- Status
Similar threads
- Locked
- Question
- Locked
- Question