[AccessD] Shading some fields in some rows on a report

Susan
I'm not clear what fields are where, but you must set BackColor back to
White for the ones you want to show. Once you set  field's BackColor to
0 it will stay that way until the end of the report unless you reset it.

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-admin at databaseadvisors.com 
> [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Susan Zeller
> Sent: 19 February 2003 21:28
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Shading some fields in some rows on a report
> 
> 
> On my report, in the detail section, I have several fields 
> that should be blank and greyed out on some rows, but not 
> others.  Actually, there are only two rows all together and 
> one should show the data and the other should not, depending 
> on the value in another field in the detail section. 
> 
> This isn't working. Why?  Ideas?
> 
> Private Sub Detail_Format(Cancel As Integer, FormatCount As 
> Integer) If Me.STUD_COLLEGE = "other" Then
>     Me.txtother_enrl_after.BackColor = 0
>     Me.txtother_enrl_before.BackColor = 0
> End If
> End Sub
> 
> What I get is that the textboxes in both detail rows are 
> blackened out when I only want them black on one row and not 
> the other.
> 
> Thanks.
> 
> --Susan
> 
> 
> Susan B. Zeller
> Office of Information Systems
> College of Continuing Education
> University of Minnesota
> 306 Wesbrook Hall
> 77 Pleasant Street SE
> Minneapolis, MN 55455
> Phone:  612-626-4785
> Fax:  612-625-2568
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>