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 |
#1
|
|||
|
|||
Report not executing code
I am running Access 2007, and have the following problem.
In my report's load event, a have the following code: If Me.Controls("txtProofReq").Value = "NO" Then Me.Controls("lblProof").Visible = False Me.Controls("txtProofDate").Visible = False Me.Controls("txtProofTime").Visible = False Else Me.Controls("lblProof").Visible = True Me.Controls("txtProofDate").Visible = True Me.Controls("txtProofTime").Visible = True End If Its purpose is to make some controls visible or not based on the data being presented. When I print preview the report, it works as expected. However, when I send the report directly to the printer without being opened it doesn't work. Does anyone have any suggestions on how to make it work? Thanks in advance Mark -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201005/1 |
#2
|
|||
|
|||
Report not executing code
I'm not certain of this, but I don't think the controls have their values
during the load event. I realize there's a difference when you open in preview mode ... and I cannot account for that. I've also had similar issues, and I decided to move the code to the Report Header's OnFormat event. bob "mr3316a via AccessMonster.com" u59438@uwe wrote in message news:a8348634aa541@uwe... I am running Access 2007, and have the following problem. In my report's load event, a have the following code: If Me.Controls("txtProofReq").Value = "NO" Then Me.Controls("lblProof").Visible = False Me.Controls("txtProofDate").Visible = False Me.Controls("txtProofTime").Visible = False Else Me.Controls("lblProof").Visible = True Me.Controls("txtProofDate").Visible = True Me.Controls("txtProofTime").Visible = True End If Its purpose is to make some controls visible or not based on the data being presented. When I print preview the report, it works as expected. However, when I send the report directly to the printer without being opened it doesn't work. Does anyone have any suggestions on how to make it work? Thanks in advance Mark -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201005/1 |
#3
|
|||
|
|||
Report not executing code
The code should be in the On Format event of the report section containing
the controls. -- Duane Hookom MS Access MVP "mr3316a via AccessMonster.com" u59438@uwe wrote in message news:a8348634aa541@uwe... I am running Access 2007, and have the following problem. In my report's load event, a have the following code: If Me.Controls("txtProofReq").Value = "NO" Then Me.Controls("lblProof").Visible = False Me.Controls("txtProofDate").Visible = False Me.Controls("txtProofTime").Visible = False Else Me.Controls("lblProof").Visible = True Me.Controls("txtProofDate").Visible = True Me.Controls("txtProofTime").Visible = True End If Its purpose is to make some controls visible or not based on the data being presented. When I print preview the report, it works as expected. However, when I send the report directly to the printer without being opened it doesn't work. Does anyone have any suggestions on how to make it work? Thanks in advance Mark -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201005/1 |
#4
|
|||
|
|||
Report not executing code
Thanks for the help!
Duane Hookom wrote: The code should be in the On Format event of the report section containing the controls. I am running Access 2007, and have the following problem. In my report's load event, a have the following code: [quoted text clipped - 21 lines] Thanks in advance Mark -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201005/1 |
Thread Tools | |
Display Modes | |
|
|