Change Line Colour Programatically in a Report

[Simon]

On a report I've built I'm wanting to change the colour of an actual line
(not a row of data) which is called line119; it runs the width of the report
will act like a traffic light to reader. I would like to change its colour
depending upon which of four categories the report falls under ie this single
line would be Purple if cat 1, Red if cat 2, Blue if cat 3 and Yellow if cat
4 - I am happy I can use a select case statement to help here.

Is it actually possible for me to set the colour of this line once the case
is met though? The line is in the detail section on my report. I need to know
which event to use and how to get to the border colour and change it.

Thanks for any help you can offer.

Simon

 

[Allen Browne]

Use the Format event of the Detail section to set the BorderColor property
of the line to an RGB value.