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

Can you make a field shrink in a report based on the value of another field?

P: 4
I am having a problem with a report. I want an entire row to shrink up to save space if all the fields in the row are null. I understand that you can use the "Can Shrink" to make a single field shrink, but how do I make the corresponding label dissapear as well and then shrink up?
Aug 10 '10 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,221
Do you want the entire row to not appear at all? You can handle in the On_Format event. Something like this
Expand|Select|Wrap|Line Numbers
  1. if isnull(me!txtbox1) and isnull(me!txtbox2) and ... then docmd.cancelevent
  2. endif
  3.  
Jim
Aug 11 '10 #2

Post your reply

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