Lawrence Mrazek
lmrazek at lcm-res.com
Thu Mar 13 10:01:00 CST 2003
Greetings:
Using Access XP. I calculated field in the detail section of a report
that compares an invoice amount with a check amount. I'd like the
textbox to display if the value of the textbox does not equal zero. I've
tried to use the following code in the "OnFormat" property of the detail
section:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
On Error GoTo ERR_OnFormat
If Me.Difference = 0 Then
Me.Difference.Visible = False
End If
Exit_ERR_OnFormat:
Exit Sub
ERR_OnFormat:
MsgBox Err.Description
Resume Exit_ERR_OnFormat
End Sub
This code correctly detects the first textbox where the value <>0, but
doesn't find any others (I've checked, and I should have a couple of
other textboxes displaying).
Thanks in advance for your help.
Larry Mrazek
LCM Research, Inc.
lmrazek at lcm-res.com
http://www.lcm-res.com
-