Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
When you print a Form there are times when you'll have text in the fields that may get cut off or the box is too big for the text that's in it. There are two Field properties that can come in handy to change the size of a bound control box as needed, Can Grow and Can Shrink. Note that these properties don't affect how the form looks onscreen; it only makes the adjustments on your printouts. Open up the Customers Order Form at the bottom of your Navigation pane. Let's see how this will print, go to the File tab, down to the Print option and click on Print Preview.
See how the Notes field is cut off and our Orders Subform is holding space for orders that don't exist. We can fix both of these problems. Close the Print Preview and switch your view for the Form to the Design View. Open up the Property Sheet, either by pressing this button in the ribbon or F4 on your keyboard, click on the Notes field, make sure you're on the Format tab in the Property Sheet and scroll down to the bottom. Here is the field for Can Grow, I'll change this to Yes; here is Can Shrink, I'll change this to yes as well.
Now, click on the Subform and make sure it says Orders Subform right here. If you're in Layout View, you can still pick the Subform except that it might not say Subform right here, which is why I prefer the Design View for this technique. At the bottom of the Properties, Can Grow is already set to Yes, but let's change Can Shrink to Yes as well. We'll go back to our Form View, back to the File tab, down to Print and across to Print Preview again. Now when I look at my form I can see all the text in our Notes and the list of Orders is the exact same size as the content.
Can Grow and Can Shrink are excellent fields to use, to make sure your printouts look as good as your onscreen forms.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64717 Viewers
80 Video lessons · 124327 Viewers
52 Video lessons · 60259 Viewers
59 Video lessons · 46095 Viewers