Change a tick box size in a report

  • Thread starter Thread starter Leo
  • Start date Start date
L

Leo

Hi,

I was wondering if anyone knows how to change the size of a tick in a
report (from a check box in a table/form). I have seen the threads and
been able to do it in a form but what about a report? Any help would be
greatly appreciated.

Regards
Leo
 
See this article:
Check boxes on reports: change the size, color, unbox them, and ...
at:
http://allenbrowne.com/ser-52.html

The article explains how to use a text box with a WingDings character that
looks like a check box, so you can resize it.

If you have a good trick for enlarging a clickable check box on a form
visually, we would love to know about it.
 
Allen Browne said:
See this article:
Check boxes on reports: change the size, color, unbox them, and
... at:
http://allenbrowne.com/ser-52.html

The article explains how to use a text box with a WingDings character
that looks like a check box, so you can resize it.

If you have a good trick for enlarging a clickable check box on a form
visually, we would love to know about it.
Click to expand...

Allen, Fred Gutkind has a workaround for this that he's posted often.
It involves using a label with the Wingdings font, and using its Click
event to change the (hidden) check box.
 
Thanks, Dirk (and Fred.)

I see how that would work in Form view (not datasheet or continuous.)
 
Thanks, Dirk (and Fred.)

I see how that would work in Form view (not datasheet or continuous.)
Click to expand...

I've done it in Continuous form view also (Access 2000 or newer).

Use an unbound text control. FontStyle Wingdings, FontSize 18 (or
whatever).
Set it's ForeColor to the same as it's BackColor (i.e. white on
white).
Set it's control source to:
= chr(252) (just the check mark)

If you want the box around the check mark .. (I don't), set the
BorderStyle to solid, Border Color to Black (or whatever). BorderWidth
to 2 (or what ever suits you).

Set it's Conditional Formatting to
Expression Is [CheckBoxName] = True
Set the ForeColor to Black (or whatever other color you want).

Code it's Click event
[CheckBoxName] = Not [CheckBoxName]

Resize the control so the box (it's border) fits properly around the
check mark.
The Border serves as the empty box when the value is False.

I think that's about all there is to it.
 
Thanks, Fred.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

fredg said:
Thanks, Dirk (and Fred.)

I see how that would work in Form view (not datasheet or continuous.)
Click to expand...

I've done it in Continuous form view also (Access 2000 or newer).

Use an unbound text control. FontStyle Wingdings, FontSize 18 (or
whatever).
Set it's ForeColor to the same as it's BackColor (i.e. white on
white).
Set it's control source to:
= chr(252) (just the check mark)

If you want the box around the check mark .. (I don't), set the
BorderStyle to solid, Border Color to Black (or whatever). BorderWidth
to 2 (or what ever suits you).

Set it's Conditional Formatting to
Expression Is [CheckBoxName] = True
Set the ForeColor to Black (or whatever other color you want).

Code it's Click event
[CheckBoxName] = Not [CheckBoxName]

Resize the control so the box (it's border) fits properly around the
check mark.
The Border serves as the empty box when the value is False.

I think that's about all there is to it.
Click to expand...
 
Back
Top