If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Conditionally Format A Line?
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/For...ports/201005/1 |
#12
|
|||
|
|||
Conditionally Format A Line?
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/For...ports/201005/1 |
|
Thread Tools | |
Display Modes | |
|
|