 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / January 2005Visible property on Report
Access 97 I have a form with a button that opens a report using a macro. The macro has a where condition to display the matching record. When the report opens I want to make a label control visible based on a text box (data field). I wrote an IF statement for the on Open event of the report: If Me!XYZ <> "N/A" Then Me!lblXYZNote.Visible = True End If I get an error saying that the expression refers to an object that doesn't have a value. It is a textbox control with the control source being a field in the table. How should I go about this? Thanks Try to use Format event of corresponding report section  SignatureAlex Dybenko (MVP) http://Alex.Dybenko.com http://www.PointLtd.com > Access 97 > [quoted text clipped - 15 lines] > How should I go about this? > Thanks Thanks - that did the trick. Forgot about that event. :) > Try to use Format event of corresponding report section > [quoted text clipped - 17 lines] > > How should I go about this? > > Thanks |
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.