Check Box

[Guest]

I have a report that gets its data from an open Form. One of the items is a
set of Check Boxes - what I am trying to figure out is I don't want the Check
Boxes to appear on the report if they are UnChecked on the form. Here is the
control source path that I use to link it to the Form - Can I add somthing to
this path that saids don't display If Null.

=Forms![F-Fill In Time Card-By Tag]!Check01

Thanks

 

[tina]

not to hide the checkbox control itself, no. you'd have to do that in code,
probably in the report section's Format or Print event procedure, something
along the lines of

Me!CheckboxName.Visible = Me!CheckboxName

in the above, CheckboxName refers to the name of the checkbox control *in
the report*, not in the form. if the above doesn't work (it depends on the
timing of when the value of the calculated checkbox control is assigned),
then try

Me!CheckboxName.Visible = Forms![F-Fill In Time Card-By Tag]!Check01

the above goes all on one line, of course, regardless of linewrap in this
post.

hth

 

[Allen Browne]

A really simple way to do this is to replace the check box on the report
with a text box, set up in such as way that it shows the Wingdings character
for a check mark when the checkbox on the form is true, and nothing for
false.

Details in:
Format Check boxes on reports: size, color, unbox, conditionally format
at:
http://allenbrowne.com/ser-52.html