Access 2007 FAQ
How can I alternate the back color of records in a datasheet form or query?
For the first time ever, Access includes the built in ability to alternate the back color of records in a datasheet, form, or query. In previous versions, you had to use custom code to have this effect.
Open your form (or query datasheet) and click the Home tab on the Ribbon, Next, click the arrow on the Alternate Fill/Back Color button in the Font group and select a color from the new color picker, as seen below.
Access now applies this back color to the alternating records. How easy is that?! 
Important Note:
You can also make this change when you open a form in Design or Layout view. In Design view, this option is also available in the Font group on the Design tab and in Layout view, you'll find it in the Font group on the Format tab.
Have fun with this new feature!
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page