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 -