Change property in a closed report

Posted on 2009-04-22
Last Modified: 2013-11-28
Hi Experts
I there a way to change the visible property in of a text control of a closed report?
Thank you
Question by:dory550
    LVL 77

    Expert Comment


    You can open it in design view, hidden, make your changes, save it and close it.

    LVL 65

    Expert Comment

    Not that Im aware of. You could maybe open it for edit/hidden then change it then save it
    LVL 65

    Accepted Solution

    this is how you open in vba as edit/hidden

    DoCmd.OpenReport "myreport", acViewDesign, , , acHidden

    this is how you can make changes to your report

    Reports("myreport").Report.Field1.Visible = False

    This is how you end up saving it

    DoCmd.Close acReport, "myreport", acSaveYes

    LVL 46

    Expert Comment

    Hi Dory

    What's the problem in changing the visible property in the report open event?
    If it's closed, nobody sees it anyway!


    Author Closing Comment

    Your  solution worked like a charm ...
    Thank you

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now