View Single Post
  #1  
Old May 18th, 2010, 10:07 PM posted to microsoft.public.access.reports
mr3316a via AccessMonster.com
external usenet poster
 
Posts: 4
Default 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