Formatting a report

  • Thread starter Thread starter accessuser1308
  • Start date Start date
A

accessuser1308

Is there a way to format a report such that every other record displayed is
highlighted? For example record 1 would be 'normal' while record 2 would be
highlighted, say yellow, all the way across the report...and so on. Is this
possible in access?

Thank you
 
On the On Print Event of the Detail section of your report, add the following:


If Me.Section(0).BackColor = 16777215 Then
Me.Section(0).BackColor = 8454143
Else
Me.Section(0).BackColor = 16777215
End If


Hope this helps,
Jackie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I apply format to an individual Access table or report rec 6
How to export reports to html format automatically 0
Displaying gif images in a report 5
Excel Staff Grade and Shift 0
2 columns reports set up and report footer 1
Adding row in a report 2
Access Access Report Works on One Machine but not Another 3
Running reports in a multiuser VB/Access environment 0

Back
Top