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

Susan Zeller szeller at cce.umn.edu
Wed Feb 19 15:30:00 CST 2003


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





More information about the AccessD mailing list