Shared Tutorials


  Shared Tutorials New
  Website Development
  2D & 3D Graphics
  Audio & Video Editing
  Databases
  Desktop Programming
  Operating Systems
  Business Applications
  Miscellaneous
  Selected Reading

© 2011 TutorialsPoint.COM


  Top Tutorials     New Tutorials     Submit     Login     Register     Forums  

Shared Tutorials Directory

Tutorials Shared by the Community




Tutorial Statistics

  • Total Hits: 1520

  • Average Rating : URL RatingURL RatingURL RatingURL RatingURL Rating

  • Total Votes: 0 votes

  • Category: MS Access/Reports

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

  • Submitted By: Shekhar

  • Set as Favorite

Tutorial Detail ( View Tutorial )

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




  

Advertisement

Online Image Processing

Indian Baby Names