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