check box

[cc]

I am trying to make the check boxes in a report stand out. Can I make a
check box in a report have a fill color? If so, can I have it only contain
the fill color when it is checked. (Unchecked boxes also appear in the
report.)

 

[Duane Hookom]

Check out Allen Browne's solution at http://www.allenbrowne.com/ser-52.html.

 

[fredg]

I am trying to make the check boxes in a report stand out. Can I make a
check box in a report have a fill color? If so, can I have it only contain
the fill color when it is checked. (Unchecked boxes also appear in the
report.)

Sure.... but not using a check box control.

Add an unbound text control to the report.
=IIf([CheckField] = -1, chr(252),"")

Set it's Font style to Wingdings.
You can size the check however you wish by setting it's Font Size, for
example, to 16.
Set the controls Height and Length properties to 2.0"
Set it's BorderStyle to Solid (if you wish the box, otherwise you can
set the BorderStyle to Transparent).

Set the control's Conditional Formatting property to
Expression Is
[CheckField] = -1

Select the Back color (and ForeColor if you wish)
Click OK

You can adjust it's size bigger or smaller as you wish.

Only the box will appear if the value is not checked.

 

[Marshall Barton]

I am trying to make the check boxes in a report stand out. Can I make a
check box in a report have a fill color? If so, can I have it only contain
the fill color when it is checked. (Unchecked boxes also appear in the
report.)

No. But you can use a text box instead.

Set the text box's Font to WingDings or whatever font that
contains an acceptable checkmark and set the Format property
to
;[Red]{check char};""
where [check char} is whatever character is the checkmark in
the chosen font.

I usually use Arial X instead of some fancy character.