How to manage the formatting of a Report programically in VBA

[geekay]

Hellooo

Will anybody help me to sort out the problem below.

I have a report which prints certificates. The various fields of the report are to be positioned by the user as per his needs, the orientation is either landscape or portrait as per the user's choice, the width and height are also the user's choice. The user changes the parameters in a form and it gets saved into a table. The report takes these values from the table and the page setup is set as per these values when it is opened.

Now my problem is that; though I can manage the position of the fields, the orientation can not be managed by the code as the property is read only. Ofcourse the user can change the orientation from the menu bar or tool bar. But I want to do it programically so that the user need to set the values only once by setting it in a form.

Please help me by suggesting a method to manage the read only properties of the report.

Many thanks for reading this posting. Hope to get your help too.

 

[Adeptus]

A possible alternative...
Set up copies of the report in both portrait & landscape, then open the required one based on the user's selection on the form.