Can Grow & Can Shrink Properties in Reports

In this video, I'll teach you how to use the Can Grow and Can Shrink properties in Microsoft Access Reports so that you can eliminate empty vertical space in a customer report if there are no notes specified on that record.

Corinne from Rome, Italy (a Platinum Member) asks: I have a simple customer report. I want to see First Name, Last Name, and Notes. If there are Notes, I want them to all display. That works fine. If there are NO Notes, I want the report to resize so there isn't as much wasted space. How can I do this?

Members

Members will learn how to display the "Notes" label next to the Notes field, but hide it if there are no Notes. We will also learn how to display an image (picture) if one exists, but hide it if there isn't one.

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Access Beginner 9: https://599cd.com/ACB9
• Images: https://599cd.com/Images

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Merch Store - Get your swag here! Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, can grow, can shrink, cangrow, canshrink, can grow can shrink access report, access can shrink not working, resize text box, resize control, go home, can shrink images, can shrink image control, can shrink pictures, resize images, visible, report section height, height property