check box

  • Thread starter Thread starter cc
  • Start date Start date
C

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.)
 
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.)
Click to expand...

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.
 
cc said:
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.)
Click to expand...


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.
 
Back
Top