<div>
Just one additonal note to Brian's suggestion. &nbsp;OnFormat can get fired off multiple times if Access retreats up the page, so wrap the code he gave you in a check like this:<br />
<br />
<br />
&nbsp; If FormatCount = 1 then<br />
&nbsp; &nbsp;'Brian's code here<br />
&nbsp; End If<br />
<br />
&nbsp; This way, your background color will only toggle once.<br />
<br />
Jim
</div>


Just one additonal note to Brian's suggestion.  OnFormat can get fired off multiple times if Access retreats up the page, so wrap the code he gave you in a check like this:


  If FormatCount = 1 then
   'Brian's code here
  End If

  This way, your background color will only toggle once.

Jim

<div>
<div class="content wysiwyg-content">
I do have a report with a lot of data. To get a proper view on this, I would like to have every second line with a grey background. How to do??
</div>
</div>


I do have a report with a lot of data. To get a proper view on this, I would like to have every second line with a grey background. How to do??

every second line in a report with grey background

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.