<div>
Thanks for the conclusion. &nbsp;I was able to just switch my report to the alternative layout altogether, however, I'll remember this for next time in case I run into this situation again.
</div>


Thanks for the conclusion.  I was able to just switch my report to the alternative layout altogether, however, I'll remember this for next time in case I run into this situation again.

<div>
That was easy. &nbsp;I've never had anyone request the option for z-order to be specified at runtime. &nbsp;A report almost always makes the most sense one way or the other.
</div>


That was easy.  I've never had anyone request the option for z-order to be specified at runtime.  A report almost always makes the most sense one way or the other.

<div>
<div class="content wysiwyg-content">
I have a report in an Access project that is for labels. &nbsp;In the report's setup under the File, Page Setup, Columns it is set to Number of Columns = 3 and Column Layout is Across, then Down. &nbsp;I would like to give the user the ability to check a box on a form and change the Column Layout to Down, then Across during runtime. &nbsp;<br />
<br />
Only some of my users want this type of layout, which is why I want to make it operational via a checkbox. &nbsp;Can someone tell me how I would do this programmatically with VBA? &nbsp;I was messing around with PrtMip, but I cannot get it to work. &nbsp;Do I need to do this on the 'On Open' event within the report - or am I supposed to do this when I call the opening of the report?
</div>
</div>


I have a report in an Access project that is for labels.  In the report's setup under the File, Page Setup, Columns it is set to Number of Columns = 3 and Column Layout is Across, then Down.  I would like to give the user the ability to check a box on a form and change the Column Layout to Down, then Across during runtime.  

Only some of my users want this type of layout, which is why I want to make it operational via a checkbox.  Can someone tell me how I would do this programmatically with VBA?  I was messing around with PrtMip, but I cannot get it to work.  Do I need to do this on the 'On Open' event within the report - or am I supposed to do this when I call the opening of the report?

Column Layout in Access Xp VBA Report

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

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.