[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?

You never "unblank" them?

> 
> 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

ELSE
    Me.txtother_enrl_after.BackColor = xxxxx
    Me.txtother_enrl_before.BackColor = xxxxx


> 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/accessd
> Website: http://www.databaseadvisors.com


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.