I am encountering a problem when I modify the properties of labels and text boxes using VBA code. If I make an object’s visible property to false it does disappear however it still seems to take up space. I then tried to set the height property to 0 this worked however the detail section appears to be taking up too much space. Next I tried adjusting the Detail Section Height then it appears I am losing some of the auto sizing features of the detail section such as eliminating blanks spaces for bound objects that have no data. What am I doing wrong if someone could point me in the right direction it would be greatly appreciated.

Thanks

Try setting the fields' and the detail section's Can Grow and Can Shrink properties to TRUE in the report's design view.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks Serrano G

I have those options already set, I guees I should also mention that we are using an access adp file as a front end incase that makes a difference. Basically the way want this report to work is that I have column headers that can start any where on the page, because we have a bunch of other stuff on the page for page and report headers. We haven't figured out yet how to group using ADO as well. I hope that this helps someone to help me.

Thanks

I guess I do not understand what exactly you are trying to do. The can grow can shrink should take care of the vertical problem. You seem to want to go horizontal.



Sal