[AccessD] Conditional Display of TextBox in Report Detail

Thanks for the hints Joe & Gustav ... I'm now seeing some more wackiness
for the report, as it is giving me incorrect values for the textbox (for
example it is evaluating the expression: 17804.94 - 17804.94 to equal
-3.637978807E-12. I'm going to go over this report to see if they built
it correctly. 

Thanks again for the hints.

Larry Mrazek
LCM Research, Inc. 
lmrazek at lcm-res.com
http://www.lcm-res.com

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Joe O'Connell
Sent: Thursday, March 13, 2003 10:23 AM
To: accessd at databaseadvisors.com; lmrazek at lcm-res.com
Subject: Re: [AccessD] Conditional Display of TextBox in Report Detail


Larry,

If your textbox has a transparent background and transparent border, try
changing the source for the textbox to display nothing.  The source
would be something like this: = Iif(datafield=0,"",datafield)

Joe O'Connell
joconnell at indy.rr.com


-----Original Message-----
From: Lawrence Mrazek <lmrazek at lcm-res.com>
To: accessd at databaseadvisors.com <accessd at databaseadvisors.com>
Date: Thursday, March 13, 2003 11:06 AM
Subject: [AccessD] Conditional Display of TextBox in Report Detail


|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
|
|-
|
|_______________________________________________
|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
-


-