Passing [color red]Colors via Formula from VB Possible?

[rchandr3]

Hi all,

By using formulas, (font_color) we can set the field color on the Crystal Reports. Is there any way that these format fields formulae like font_color, object_visibility be passed from VB?

I am sure it would be helpful to lots of people if someone could share their insight.

Thanks a lot

 

[Reebo99]

I don't know of a way to do this solely within VB, but you can pass this as a parameter then set conditional formatting on text items.

It does mean that you would have to allow for every type of colour within yourconditional format formula.



Reebo
UK

"Before you judge a man, walk a mile in his shoes. After that, who cares? ...He's a mile away and you've got his shoes." - Billy Connolly

 

[lyanch]

You can set virtually any color if you set three parameters, one each for red, green and blue and then set the font color (in x->2) to:

color({?red},{?blue},{?green})

Lisa