Creating Alternate Row Colours in a MS Access Report
Tutorials Shared by the Internet Community
Creating Alternate Row Colours in a MS Access ReportYou can use the AlternateBackColor property to specify a color to be displayed or printed on every other line in the detail section.
Total Hits - 38630
Total Votes - 114 votes
Vote Up - 50 votes
Vote Down - 64 votes
Domain - www.databasedev.co.uk
Category - MS Access/Reports
Submitted By - Shekhar
Submitted on - 2008-04-15 07:49:20
In previous versions of Microsoft Access, namely 2000, XP and Microsoft Access 2003, we had to use VBA code to produce alternate row colours on a Microsoft Access report.
We did this by adding code to the On_Format event of the report. We can see the required code in a previous article, found at Alternate row colors on reports with Microsoft Access
By default, Access formats each row of a report's detail section with the same background color. When printing a report, shading every other line of the detail section can make it much easier to read. With Microsoft Access 2007 this process has been greatly simplified, and we can create the alternate row colors by setting the Alternate Fill/Back Color from the detail properties of the report or from the Font tools on the Format tab of the Report Layout Tools.
Please use the following link to visit the site. There is a possibility that this content has been removed from the given URL or may be this site has been shut down completely.http://www.databasedev.co.uk/alternate_rows_2007.html