Many accounting style reports need help to be more readable. Ever used a ruler on a landscape report to make sure you read data from the correct row? Remember the old green bar reports from mainframes that made this easier? Well, you can accomplish the same type of layout on an Access report.
Make sure the BackStyle of each control is Transparent.
Code the Detail Format event:
If Me.Section(0).BackColor = vbWhite Then
Me.Section(0).BackColor = 12632256 ' gray
Else
Me.Section(0).BackColor = vbWhite
End If
Subscribe to:
Post Comments (Atom)
Atom Feed (xml)
1 comment:
Perfect and easy solution... especially compared to other solutions that reference each field (the data) in the report. Thank you!
Post a Comment