[AccessD] Conditional Display of TextBox in Report Detail

Joe O'Connell joconnell at indy.rr.com
Thu Mar 13 15:59:00 CST 2003


Larry,

Be sure that all fields that contain monetary amounts are defined as
Currrency and not as Double.

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 4:49 PM
Subject: RE: [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
|-
|
|
|-
|
|_______________________________________________
|AccessD mailing list
|AccessD at databaseadvisors.com
|http://databaseadvisors.com/mailman/listinfo/accessd
|Website: http://www.databaseadvisors.com





More information about the AccessD mailing list