I have a report that is grouped by "function". .. there are two functions that do not need the last column of the report as it is always blank. I would like to check the group header value, and remove this label and text box from that report. I have played around with the visible function but cannot seem to get it to work. Once I can get the field removed for those two pages, I would like to increase the width of the text box next to the one I am removing. I can provide more details if needed. Any help appreciated. Thanks!
-
-
You can set the value of .Visible in the Section.Format event. -
Awesome, thanks! I had it in the wrong section :)
Can I do the same in the detail section for the associated text box? Also, is there a way to adjust text box to the left to make it wider?Comment
-
Actually got it figured out. Thanks again!Comment
-
Very pleased to hear it. Actually, what you're planning sounds like fun. I've done such things in the past myself and it opens up doors that allow you to design forms and reports so that one object can handle so many more requirements. It really is good to see how flexible things can be when controls are resized and moved around based on the numeric .Height, .Width, .Left and .Top values.
Good for you :-)Comment
Comment