Coloring Alternate Rows in a Form or Report

You can create forms and reports that display one table or query record per page, but viewing data one record at a time can take away your ability to relate one record to the next. Viewing multiple records on a form or report helps you spot patterns in your data, but distinguishing one row from another can be difficult unless you change the formatting to make the rows stand out from their neighbors. In Access 2007, you can format your form or report so that alternating data rows have a different background color. You can choose whichever color combinations you’d like, but bear in mind that a combination that works well onscreen might not work well on the printed page. Test your choices to figure out ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.