Yes and No - Just don't get it!

J

joey

I've spent hours looking for the answer on how to just have Checkboxes
clicked for Yes display on the report rather than all the Checkboxes. I have
checked previous postings but I just don't get the answers. Can someone
please explain how to do this in a step-by-step guide for this newby?
 
R

Rick Brandt

joey said:
I've spent hours looking for the answer on how to just have Checkboxes
clicked for Yes display on the report rather than all the Checkboxes.
I have checked previous postings but I just don't get the answers.
Can someone please explain how to do this in a step-by-step guide for
this newby?
Click to expand...

Find the OnFormat event property box for the section where the CheckBoxes
reside. In that box enter "[Event Procedure]" from the list of choices and then
press the build button [...] to the right of the box.

You will be taken to theVBA code window positioned within the sub-procedure that
will run in the format event of the section. Since the Visible property is
True/False and the value of a CheckBox is also True/False you are in luck. You
can simply enter code of...

Me.CheckBoxName.Visible = Me.CheckBoxName

....for each CheckBox. When the Checkbox value = True it will be visible. When
the value is False it will be hidden.
 
F

fredg

I've spent hours looking for the answer on how to just have Checkboxes
clicked for Yes display on the report rather than all the Checkboxes. I have
checked previous postings but I just don't get the answers. Can someone
please explain how to do this in a step-by-step guide for this newby?
Click to expand...

Easiest way for me is to just code the report's Detail Format event
(assuming the check box is displayed in the Detail Section):

Me![CheckBoxName].Visible = Me![CheckBoxName]
 
C

Crystal

Hi Joey,

In cases like this, you may want to use a calculated control
rather than a checkbox control. For instance, to display
"X" or nothing...

in the recordset of your report...

field --> ChkName: IIF(checkbox_fieldname, "X", "")

substitute whatever you want ot call the calculated field
for "ChkName"

Then use this field on the report

Have an awesome day

Warm Regards,
Crystal
 
Top