Set properties of report sections using VBA

Topic

New Reply

My reports is built dynamically as the columns can change . everything seems to be working OK but I would like to be able to set the height of Headers, Footers as the report is built and I have not been able to find a way to do that. Any suggestions greatly appreciated.

Thanks

peter

Reply | Quote

Replies

I haven’t tried it but how about setting the height of a hidden rectangle.

Reply | Quote

WIll try that it should work as long as I have shrink grow turned on. Seems like it should be easier than that, Thanks for you time.

Reply | Quote

Note: Building reports dynamically with VBA code is not commonly done. It does require a lot of work.

Most people deploy their front end as an mde/accde which prevents you from being able to build reports dynamically. I hae a crosstab report that can vary in the number of columns. I do not have to modify the report design at runtime to handle this. This allows me to lock it down as an mde/accde. See: Dynamic Report based on a Crosstab query

Reply | Quote