Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Access 2010 Power Shortcuts, Access expert Alicia Katz Pollock shares hundreds of tips and shortcuts to vastly increase efficiency and get the full power out of Access 2010. The course includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Exercise files accompany the course.
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.
There are currently no FAQs about Access 2010 Power Shortcuts.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.