 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / October 2005Conditionally visible line
Hello, Is there a way to set the visibility of a line that is located in the detail section of a report according to a value in the current record? The line's visible property does not seem to accept a formula. Regards, Jack If you have a control in your report's detail section like Name: txtMaxFlowRate Control Source: [MaxFlowRate] and a line: Name: linMaxFlowRate You can add code to the On Format event of the detail section like: Me.linMaxFlowRate.Visible = (Me.txtMaxFlowRate > 2000)  SignatureDuane Hookom MS Access MVP > Hello, > [quoted text clipped - 6 lines] > > Jack That's true. Thank you! Jack |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.