dynamicaly adjust the report width

S

Steve S

I have a report with 1- 4 comulns each with 1-6 subcolumns. The base report
is 22" wide and I adjust the placement of columns with Me.txtAbc.left=twips.
in most cases the printed report will fit on letter paper landscape. The
problem is there are extra blank pages between good pages.

Is there a way to dynamicaly adjust the report width so the extra pages do
not get printed??

Also is there a way to dynamicaly set paper size and orientation??

I have tried Me.width=SomeNumberOfTwips but that does not change the report
width. I put this in the ONOpen event of the report.

Any and all help is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top