Formatting a Box to change Colors when a condition is met

[terenceb]

Hi All,

I am pulling date from SQL tables on a Cashe database. I am writing with Crystal 8.5.

I need draw a box in a form, to be used as check box. When a condition is met I want the box to turn black. However when I draw the box and right click on it I only see "Format Box" which does not allow for formula input.
Any suggestions?

 

[bdreed35]

You can use a text object instead of drawing the box. Don't add any text and use the borders simulate a box.
You can then conditionally set the border color based upon your condition.

~Brian

 

[fredp1]

A neat way is to use the WEBDINGs font.
Use "c" for a Open box and "g" for a closed box.
That way you can have a formula to change the box from open or closed.
i.e if condition1 then "c" else "g"
then specify the font to be webdings for that field.

Fred
P.S.
To have a look at the different symbols, goto to the control panel, Fonts, then pick a font to look at.
Webdings, Wingdings is a good start.