Increasing the size of a reports detail section

[Tammy]

PLEASE HELP! I am developing a database with the main purpose of generating detailed reports for our users. One report is quite large and I have now come to the point where Access will not allow me to increase the size of the detail section for the report and there is currently no way I can fit all the information in the detail section. It says that the maximum size for the detail section is 22". Does anyone know how to change this or even if Access 2000 may have different capablities? Thanks in advance.

 

[Atomic Shrimp]

Crikey, you must have a lot of data!

How about splitting it into a set of subreports, then inserting them all into the detail section on the main report?

 

[Travis]

Depending on formating of the report, if you just have line after line of data and are not trying to duplicate a standard form you can use this trick.

Change the control properties Can Grow to True. Then Reduce the hieght of the controls to practacly nothing. Reduce the space between the controls but keep them from touching as this will prevent the growing from occuring. On the On_Format Event you will need to resize any corresponding labels to the controls size. (Extra Code I know)

Unfortunatly this will not increase the 22" limit but may increase your workable space.