<div>
open the db, and select the Report, then hit F2 and change the name<br />
<br />
or right click on the Report and then select Rename
</div>


open the db, and select the Report, then hit F2 and change the name

or right click on the Report and then select Rename

<div>
<div class="content wysiwyg-content">
I am using the OutputTo method in Access. I want to strip the reserved characters for naming Windows files in a string and replace them with a string that does not cause an error.<br />
<br />
Example: report name to export is &quot;10/19/11 Inventory, Current&quot;. I want to rename as &quot;10-19-11_Inventory_Curren<wbr />t&quot;. <br />
<br />
Thanks
</div>
</div>


I am using the OutputTo method in Access. I want to strip the reserved characters for naming Windows files in a string and replace them with a string that does not cause an error.

Example: report name to export is "10/19/11 Inventory, Current". I want to rename as "10-19-11_Inventory_Current". 

Thanks

Acess VBA: How do I replace reserved characters in a string?

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.