 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / September 2005Checkbox in report detail
Hi-- I have a checkbox in the detail section of a report. I need to make it visible or invisible programatically. I believe that I can do this using the On Print event of the detail. My problem is that I cannot determine the code to accomplish it. The checkbox name is SuperT. Thanks for the help! Don You can add code to the On Format event like Me.SuperT.Visible = [some condition relating to bound values]  SignatureDuane Hookom MS Access MVP > Hi-- > I have a checkbox in the detail section of a report. I need to make it [quoted text clipped - 3 lines] > Thanks for the help! > Don > I believe that I can do this using > the On Print event of the detail. My problem is that I cannot > determine the code to accomplish it. The checkbox name is SuperT. Actually, I think it's the OnFormat event of the Detail section. If This = ToBeHidden SuperT.Visible = False Else SuperT.Visible = True End If or the shorter version SuperT.Visible = Not (This = ToBeHidden) Hope that helps Tim F Thanks so very much. I guess that there are properties that do not come up when you type the period after the control name, eh? Don > Hi-- > I have a checkbox in the detail section of a report. I need to make it [quoted text clipped - 3 lines] > Thanks for the help! > Don |
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.