[AccessD] Add "Green Bar" effect to your Access Reports

Lonnie Johnson prodevmg at yahoo.com
Thu Sep 11 15:38:16 CDT 2003


This will give a green bar effect on a report. Every other line green. You may want to play around with the numeric color expressions if you don't like the loud green you get from vbGreen. Just a tip...
 
 
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Detail.BackColor = vbWhite Then
    Me.Detail.BackColor = vbGreen
Else
    Me.Detail.BackColor = vbWhite
End If
End Sub


 



Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us




 




---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030911/378f7aea/attachment.html>


More information about the AccessD mailing list