<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=437431402-12092003><FONT face=Arial color=#0000ff size=2>Don't
forget that all your controls should have a transparent background. You
will probably also want to put this same in the </FONT></SPAN></DIV>
<DIV><SPAN class=437431402-12092003><FONT face=Arial color=#0000ff
size=2>"Detail_Print" event besides "Detail_Format".</FONT></SPAN></DIV>
<DIV><SPAN class=437431402-12092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=437431402-12092003><FONT face=Arial color=#0000ff
size=2>John</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Lonnie
Johnson<BR><B>Sent:</B> Thursday, September 11, 2003 4:38 PM<BR><B>To:</B>
'MS-ACCESS-L@lists.missouri.edu'; AccessDevelopers; ms_access; AccessD
solving'<BR><B>Subject:</B> [AccessD] Add "Green Bar" effect to your Access
Reports<BR><BR></FONT></DIV>
<DIV>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...</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><STRONG><FONT color=#4040ff>Private Sub Detail_Format(Cancel As Integer,
FormatCount As Integer)</FONT></STRONG></DIV>
<DIV><STRONG><FONT color=#4040ff>If Me.Detail.BackColor = vbWhite
Then<BR> Me.Detail.BackColor =
vbGreen<BR>Else<BR> Me.Detail.BackColor = vbWhite<BR>End
If</FONT></STRONG></DIV>
<DIV><STRONG><FONT color=#4040ff>End Sub</FONT></STRONG><BR></DIV>
<DIV><BR> </DIV><BR><BR>
<DIV>
<DIV>
<P align=center><STRONG>Lonnie Johnson<BR></STRONG><STRONG>ProDev</STRONG>,
Professional Development of MS Access Databases<BR>Visit me at ==> <A
href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR><A
href="http://www.galaxymall.com/software/PRODEV"><BR></A><BR> </P></DIV></DIV>
<P>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo!
SiteBuilder</A> - Free, easy-to-use web site design
software</BLOCKQUOTE></BODY></HTML>