Formatting check boxes in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to format the check box in my report. I would like to remove the
border that is around the check box. Is there a way to do this?

Leslie
 
Not really sure if you can (don’t think so) but here is a little “cheat†I
have used in the past. Create a new unbound text box. Set the font as
Windings 2

Set the control source as
=IIf([TickBoxField]=-1,"O","P")

This will give a tick if the tickbox is checked and a cross if not. If you
don’t want the cross just use
=IIf([TickBoxField]=-1,"","P")


Hope this helps
 
I am trying to format the check box in my report. I would like to remove the
border that is around the check box. Is there a way to do this?

Leslie
Click to expand...

No. However you can work around it.
I assume what you want, if the check box is checked, is just the check
mark.

Use an unbound control instead of the check box control.
Set it's control source to:
=[CheckBoxField]
Set it's Format property to:
;\ü
(You can copy the above and paste it into the Format property)
Set it's BackStyle property to Transparent.
Set it's FontStyle to Wingding
Note: You can also size the font to make the check mark bigger or
smaller.

When you run the report, if the value of the field is True (checked)
you will get just the check mark.
What do you want if the value is False (unchecked)?
As of now, nothing will show.
 
Back
Top