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

Yes, easy solution indeed.  And, I'll be careful about posting field
names out of context!  STUD in STUD_COLLEGE is short for "STUDENT" and,
just for the record, I didn't make up that field name.  But, I did get a
huge laugh from thinking about how this sounded to Arthur.  

Thanks for your help.  Report working fine now.

--Susan


-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com] 
Sent: Wednesday, February 19, 2003 8:14 PM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Shading some fields in some rows on a report


Easy solution...don't kick yourself though.  You need to include an else
statement, to reverse the backcolors back.  Because what happens is that
once it sets the backcolors, it keeps that setting for the remaining
'details' or rows.  I know, I personally think they should have each
detail show up with initial settings, but I guess it is a processing
issue...constantly having to reload a new object would probably slow
things down.

Drew

-----Original Message-----
From: Susan Zeller [mailto:szeller at cce.umn.edu]
Sent: Wednesday, February 19, 2003 3: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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com