Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Formatting reports in Access
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
0 · ·