Lawrence Mrazek
lmrazek at lcm-res.com
Thu Mar 13 16:48:00 CST 2003
Hi Joe. That fixed it! Report is running correctly now. Thanks again for your help. 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 3:59 PM To: accessd at databaseadvisors.com; lmrazek at lcm-res.com Subject: Re: [AccessD] Conditional Display of TextBox in Report Detail 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com - -