I have a report which could easily have more than 10 pages. I'd wanted the records to have [green]different colors on alternate rows[/green] so that it's easier for end-users to differentiate between records. In order to do that, I had created a rectangular box, and put all the controls(5 text boxes altogether) on top of the rectangular. I make the borders and backcolor of all the controls to transparent and at the same time, the border of the rectangular to solid [black]black[/black], and backcolor [grey]greyed[/grey] if [red]Record no mod 2 =0 [/red]. This turned out to be very nice and exactly the effect as I wanted it to be. My end-users like this format very much too :-D , as it's friendlier to their eyes.
But the problem is, this format wasted a lot of ink when printed out. :-( Is there any solution whereby I can make the backcolor of the rectangular appear only when preview on screen but disappear when printed out?
Tracy Koh ;-)
IT Officer - Singapore