Creating Alternate Row Colours in a MS Access Report

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Creating Alternate Row Colours in a MS Access Report

You can use the AlternateBackColor property to specify a color to be displayed or printed on every other line in the detail section.
http://www.databasedev.co.uk/alternate_rows_2007.html
  • Total Hits: 19246

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 149 votes

  • Category: MS Access/Reports

  • Submitted on: 2008-04-15 07:49:20

  • Submitted By: Shekhar

  • Set as Favorite

Description:

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.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 38.26%  57
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.07%  15
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 12.08%  18
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 10.74%  16
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28.86%  43

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.






Advertisements