<div>
If you just change the .Visible property then you don't have to open in design and save. I run into this kind of thing because I deploy to a runtime environment only.<br />
<br />
Steve
</div>


If you just change the .Visible property then you don't have to open in design and save. I run into this kind of thing because I deploy to a runtime environment only.

Steve

<div>
True, but I think murdochah is doing this to clean up a report design rather than dynamically altering the report on the fly. I'm not sure what his circumstances are though.
</div>


True, but I think murdochah is doing this to clean up a report design rather than dynamically altering the report on the fly. I'm not sure what his circumstances are though.

<div>
I got it to work properly, my only question is this: &nbsp;does the DeleteReportControl method show up in your copy of the Access Help documentation? &nbsp;I couldn't find it in the help so I'm wondering if it's undocumented, or if my Access Help documentation has gotten corrupted somehow. &nbsp;<br />
<br />
Thanks for the help!<br />
Andrew
</div>


I got it to work properly, my only question is this:  does the DeleteReportControl method show up in your copy of the Access Help documentation?  I couldn't find it in the help so I'm wondering if it's undocumented, or if my Access Help documentation has gotten corrupted somehow.  

Thanks for the help!
Andrew

<div>
It's in my help doc - I'm using Access 2002.
</div>


It's in my help doc - I'm using Access 2002.

<div>
<div class="content wysiwyg-content">
Is there any way to delete controls from a report programmatically with VBA? &nbsp;I'm building a dynamic report that creates new textboxes, but I want to make sure that I clean up and delete previous iterations before adding the new textboxes. &nbsp;I'm aware of the apparently undocumented &quot;DeleteControl&quot; method for forms. &nbsp;Is there something similar for reports?
</div>
</div>


Is there any way to delete controls from a report programmatically with VBA?  I'm building a dynamic report that creates new textboxes, but I want to make sure that I clean up and delete previous iterations before adding the new textboxes.  I'm aware of the apparently undocumented "DeleteControl" method for forms.  Is there something similar for reports?

Delete Control from Report with VBA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.