I have a very long report. To help combat the length, I've added pseudo-collapse functionality such that when you double click a Group Header, the Group Header below it collapses or expands (really, i'm just toggling it's Visible property). This works all well and good except for one thing, if the header i double click is any header other than the very first record, the header i double click gets thrown out of view because once all of the sub-headers are expanded, it pushes the one i was looking at way down on my form. What can i do about this? i've tried:
but couldn't get it to work. And even if it did work, i'm not sure how i would specify which particular header to scroll to. Is this a lost cause? Am i on the right track? Any help would be greatly appreciated.