By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,533 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

Hide label and text box based on group header value

P: 5
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!
Apr 3 '14 #1

✓ answered by NeoPa

You can set the value of .Visible in the Section.Format event.

Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,769
You can set the value of .Visible in the Section.Format event.
Apr 3 '14 #2

P: 5
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?
Apr 3 '14 #3

P: 5
Actually got it figured out. Thanks again!
Apr 3 '14 #4

NeoPa
Expert Mod 15k+
P: 31,769
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 :-)
Apr 3 '14 #5

Post your reply

Sign in to post your reply or Sign up for a free account.