There are many different methods for changing property settings, including the following:

• Entering or selecting the desired value in a Property window
• Changing a property directly by changing the control itself, such as changing its size
• Using inherited properties from the bound field or the control’s default properties
• Entering color selections for the control by using the Ribbon commands
• Changing label text style, size, color, and alignment by using the Ribbon commands

You can change a control’s properties by clicking a property and typing the desired value.

In Figure 35-21, you can see a down arrow and a button with three dots to the right of the Control Source property-entry area. Some properties display a drop-down arrow in the property-entry area when you click in the area. The drop-down arrow tells you that Access has a list of values from which you can choose. If you click the down arrow in the Control Source property, you find that the drop-down list displays a list of all fields in the data source—tblProducts. Setting the Control Source property to a field in a table creates a bound control.

FIGURE 35-21
The Property Sheet undocked

Some properties have a list of standard values such as Yes or No; others display varying lists of fields, forms, reports, or macros. The properties of each object are determined by the object itself and what the object is
used for.

A nice feature in Access 2007 is the capability to cycle through property choices by repeatedly double-clicking on the choice. For example, double-clicking on the Display When property alternately selects Always, Print Only, and Screen Only.

The Builder button contains an ellipsis (three dots) and opens one of the many builders in Access—including the Macro Builder, the Expression Builder, and the Module Builder. When you open a builder and make
some selections, the property is filled in for you.

Each type of object has its own property window and properties. These include the form itself, each of the form sections, and each of the form’s controls. You display each of the property windows by clicking on the
object first. The property window will instantly change to show the  properties for the selected object.

• Rachmaninov: Piano Concertos Nos. 2&3 - Acoustic Reality Experience [7.1 DTS-HD Master Audio Disc] with DTS-HD Music Downloads Access [Audiophile Edition] [Blu-ray] User Reviews Send this to a friend Rachmaninov: Piano Concertos Nos. 2&3 - Acoustic Reality Experience [7.1 DTS-HD Master Audio...
• Dear Taxpayer: Good News! Your Property Tax Has Decreased ... P.S. So Has Your Property Value We received the following letter from our County Assessor-Recorder the day before yesterday. At first I was afraid to open...
• A Brilliant Craig's List Scam (Beware of DS Properties) My wife and I are doing a little apartment shopping. Our place is fine enough, but we thought we might...
• Consumer Confidence in United States has Increased The level of consumer confidence in the United States rose unexpectedly in November, rebounding from a record low. This surprising...
• 10 Ways To Change The World Through Social Media. Citizen journalism, open government, status updates, community building, information sharing, crowdsourcing, and the election of a President. Editor's note: This...