From the course: Access 2007: Shortcuts
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Selecting multiple form and report controls - Microsoft Access Tutorial
From the course: Access 2007: Shortcuts
Selecting multiple form and report controls
When you're designing a formal report, you'll frequently need to make the same formatting or location change to several labels or data boxes, which Access calls controls. Instead of making the same change to each control over and over and over again, you can select multiple objects and apply the change to all of them at the same time. I have opened my Customers Order Form. I am going to right-click on my Customers Order Form tab and open it in Layout View. When I click on any of the labels, which are the field names or the bound boxes which contain our data, they get an orange highlight around them. If I want to select more than one at a time, I can hold down my Shift key to add controls to the group. If I select too many and I want to remove one, I can just keep that Shift key down and click the control a second time. The orange box goes away. If I want to select all the boxes on the form at the same time, I can press Ctrl+A on my keyboard and everything will get a highlight. If I…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
Customizing the Navigation pane2m 38s
-
Toggling between Design and Data views2m 29s
-
Creating new fields with field templates1m 18s
-
Understanding the "Cannot contain a Null value" error1m 28s
-
Working with AutoNumbers as foreign keys2m 28s
-
Using input masks2m 30s
-
Four ways to add fields to a query1m 37s
-
Four ways to filter data2m 57s
-
Selecting multiple form and report controls2m 32s
-
Aligning and distributing controls on forms and reports4m 33s
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-