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

STUD_COLLEGE? For whom are you currently working, Susan? There are aspects
to your life of which we had no inkling :-) Let's hope that no Filipino
named Ho decides to found a college!
I know it's not Friday, but that's a helluva table name!

A.

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Susan Zeller
Sent: February 19, 2003 4:28 PM
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/accessd
Website: http://www.databaseadvisors.com