Report not executing code
in [Reports]
|
From: mr3316a via AccessMonster.com on 18 May 2010 17:07 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/Forums.aspx/access-reports/201005/1
From: Bob Howard on 18 May 2010 17:51 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(a)uwe> wrote in message news:a8348634aa541(a)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/Forums.aspx/access-reports/201005/1 >
From: Duane Hookom on 18 May 2010 23:23 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(a)uwe> wrote in message news:a8348634aa541(a)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/Forums.aspx/access-reports/201005/1 >
From: mr3316a via AccessMonster.com on 19 May 2010 07:34 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/Forums.aspx/access-reports/201005/1
|
Pages: 1 Prev: Concatenate Expression with text string in Report? Next: hiding control textbox when no data |