Conditionally Format A Line?
in [Reports]
|
Prev: Generate PDF Bookmarks in MS Access 2007 Reports
Next: how do I activate horizontal or vertical position on report
From: 1stAyd via AccessMonster.com on 17 May 2010 11:29 My code looks good, but I haven't knowingly allowed code to run. How do I do that? Thanks again, you guys are great. Duane Hookom wrote: >Have you allow the application to run code? Are you viewing the report in >Print Preview? >The code should look something like this: > Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) > Me.[Line18].Visible = (Me.[txtIPG] = "RESALE") > End Sub >To see if this code is causing the issue, try comment out the line of code >like: > Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) > ' Me.[Line18].Visible = (Me.[txtIPG] = "RESALE") > End Sub > >> Thanks, Duane, but I'll still SOL. In "On Format" of Detail it now says >> "Event Procedure", and I copied exactly what you have into the code >[quoted text clipped - 21 lines] >>>> >be tied >>>> >to a report control..... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201005/1
From: 1stAyd via AccessMonster.com on 17 May 2010 14:13
I managed to answer this one on my own. Thanks again, everyone. 1stAyd wrote: >My code looks good, but I haven't knowingly allowed code to run. How do I do >that? Thanks again, you guys are great. > >>Have you allow the application to run code? Are you viewing the report in >>Print Preview? >[quoted text clipped - 13 lines] >>>>> >be tied >>>>> >to a report control..... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201005/1 |