Maximum allowed report width

[stajosa]

Hello all,
I'm trying to allow users to choose specific columns from a certain list of total possible columns. Once they click a button, it is supposed to dynamically generate a report based on the columns that they specified. Basically I'm using a buttload of VBA code in the background to create a bunch of report controls. As each column (label+field) is created, and indent variable is incremented so each column has space to display the data. My problem is, if they select more than like 30 columns, the indent variable gets too big and it stops displaying them. I discovered that the maximum width for every report (including legal sized paper) seems to be 22 inches.
Here is the moral of my story:
Can you increase this maximum width?
Thanks!

 

[WayneRyan]

S,

Nope, 22" is the Max.

If you really need bigger, export to Word, or go with a 3rd-party solution.

Wayne

 

[stajosa]

Ah, thanks for the response.
Do you know of any other way of solving my problem inside of Access (like using page breaks or new pages as report controls), or is there no way of getting around this limited width?
I just discovered the acPageBreak and acPage CreateReportControl properties, but I'm not sure what purpose they serve aside from providing a blank page in between pages.

 

[Econ]

I suppose that you could always try to work with the font sizes in the report so that they will be reduced if your 22" limit is reached. That would allow you to jam everything together, but it would make things harder to read.

Out of curiosity - what would kind of report would someone even want with 30 columns?

 

[stajosa]

Yeah, I tried the font size thing.
It's not me that wants this... they want to be able to limit how much information to display about each item in a big list of items. So if they decide to see all the data, that's all the columns.
Well looks like I'll stick to the alternative.
Thanks for helping!

 

[Happy YN]

Is it possible to snoop at your vba code for generating the report and its controls!I have also done that but find that labels expand themselves to the with of the caption even if I specify in code that they should be ??
Thanks