How can you select all of the controls in a report in report design view?
In Report Layout view of the StoresByState report, click the first RevenueGoal value to select that control.Click the Report Layout Tools Format tab on the Ribbon.In the Control Formatting group, click the Conditional Formatting button.The Conditional Formatting Rules Manager dialog box opens.Click New Rule.The New Formatting Rule dialog box opens.Click the between arrow.A list of comparison operators appears in the list.Click greater than or equal to.The choice of comparison operators depends on what data you want to highlight with the conditional formatting rule.Click the box to the right of greater than or equal to and type 750000 in the text box.The conditional formatting rule will check to see if the current RevenueGoal field value is greater than or equal to $750,000.In the Preview area of the dialog box, click the Bold button to apply bold formatting when the rule evaluates true.You may choose any number of formatting options including bold, italic, underline, background colors, and text colors.In the New Formatting Rule dialog box, click OK to complete the new rule.The New Formatting Rule dialog box closes. At this point you could add a new rule, edit a rule, or complete the conditional formatting process.In the Conditional Formatting Rules Manager dialog box, click OK.The values in the RevenueGoal column that are equal to or greater than $750,000 are now bold. The values less than $750,000 were not formatted. Show Sets with similar termsFundamental Design Characteristics of a Windows Control The Name of a Control on a Form or Report If you add a text box or another control from the Controls section of the Ribbon to the form or report, the control would receive a default name. If you drag an object from the Field List to a form or report, the control would use the name of the field set in the table. In both cases, you can change the name of the control.To change the name of a control on a form or a report, first switch to Design View and access the Property Sheet for the control. In the Property Sheet, click the Other or the All tab:
Record and Control Source If you create a form or a report based on a table, its Windows controls would be linked to the original table where they would get their data from. Otherwise, to link a control to a field of a table, first switch the form or report to Design View and make sure you had set the form or report's Record Source property to the table that holds the field. Double-click the control to access its Property Sheet. In the Property Sheet, click either the Data or the All tab. Click the Control Source field and select an item from its combo box. Practical Learning: Setting Control Sources of Objects
The Caption of a Windows Control A caption is the word or group of words that displays on a control. If you drag a control from the Field List to a form or report, the control would use the caption set in the table for the field. Remember that if no caption was set for the field, the name is used as the caption. At any time, you can change the caption to your liking.. The controls that have a caption have a property named Caption in the Property Sheet. Practical Learning: Setting Objects Captions
Data Entry on a Form Introduction Data entry on a form is performed using Windows controls. If the control is a text box, click it and type the value. As you may know already, most controls are accompanied by a label. You can click that label to give focus to the control. If a control is a list, you will be asked to make a selection. After entering or changing data on a control, to move from one field to the next, the surest way is to press Tab. In some cases, the user can also press Enter. Practical Learning: Form Data Entry
Controlling Data Entry on a Form One of the most important roles of a form is to provide a friendly means of performing data entry. Probably the most fundamental aspect of a form is to prevent an asthetic display of records to the user. As such, a form is not necessary made for data entry. In fact, you can prevent the user from creating records using a form. This is controlled by a Boolean property named Allow Additions. Therefore, to prevent the user from creating new records using a form, open the form in Design View and access its Property Sheet. In the Data or the All tab, set the Allow Additions field to No. Practical Learning: Controlling Data Entry on a Form
The Font Applied to a Windows Control Introduction The font is the design used to paint text of the control on a form or a report. The appearance of a control of a form or a report can be improved with an appropriate font. To change the font of a control, first display its form or report in Design View:
The font you apply to any control on a form or a report doesn't have any influence on the columns of the base table. Practical Learning: Specifying the Font of a Control
The Font Size of a Control To change or set the size of the font used to display the characters of a control on a form or a report:
The Text Style of a Control To change the font style of a control, switch the form or report to Design View. Select the control or the group of controls. On the Ribbon, click either Home or Format. In the Text Formatting section of the Home tab or in the Font section of the Format tab, click the button that represents the desired style: Bold , Italic , or Underline .Instead of the buttons on the Ribbon, you can apply a style or a combination of styles using the Property Sheet. In the Property Sheet, click either the Format or the All tab:
The Text Alignment of a Control The text alignement specifies on what side the value of a field would be displayed, to the left, to the center, or to the right within the area allocated to the control. To specify the text alignment of a control: Practical Learning: Aligning Fields Text
Introduction to Colors and Windows Controls Text Color The color applied to the text of a control specifies the perception of red-green-blue that the control will show. To specify or change the color of text of a control:
The Background Color of a Control The background color specifies the color used behind the text, or on the body, of a control. To specify or change the background color of a control, if the color you want to use is one of the Microsoft Access-defined colors, on the form or the report, right-click a control or one of the selected control, position the mouse on Fill/Back Color, and click the desired color. Otherwise:
A Transparent Control If you don't want a control to be painted with a particular color, you can make it transparent. To do this, right-click the control on the form or report. Position the mouse on Fill/Back Color, and click Transparent: .Alternatively, in the Property Sheet, click the Back Style field, then click the arrow of its combo box and select Transparent. Practical Learning: Setting the Transparency of a Control
The Borders of a Windows Control The Thickness of a Border To indicate its limits, a control is surrounded by a border. By default, the border appears as a solid line. To specify or change the thickness of the borders of a control or a group of controls, first select it or select them. Then:
The Line Type of a Border Besides the thickness, you can control the border of an object with a style. To do this, first select the control or a group of controls. Then:
The available options are: The Border Style characteristic can be used in combination with the Special Effect property. Some of these effects depend on the Special Effect value and may not appear as expected. The Border Color property can be used to control the color used to draw the border of a label or a field. It is used as we described for the Fore Color property. The Border Width property is used as the Line/Border Width button of the Formatting toolbar. The Border Color of a Control To paint the borders of a control with a color of your choice. First select a control or a group of controls. Then:
Special Effects The special effect is a small feature that makes it possible to display a section of a form/report or a control flat, sunk, or raised. To apply the special effects to a control, first select the control or a group of controls. Then:
The available options are: Practical Learning: Using Special Effects
Using a Pre-Design Copying a Design Microsoft Access makes it possible to copy a design from one control to another. To do this, in the Design View of a form or report, click the control that has the desired design. On the Ribbon, click Home. In the Clipboard section, click the Format Painter button. On the form or report, click the control on whic you want to apply the design. Using a Design Template Microsoft Access provides sets of fonts and colors you can apply to the controls on a form or report. To apply them, the form or report must be displayed in Design View. The options are available in the Themes section of the Design tab of the Ribbon. To a apply a common font to all controls on the form or report, in the Themes section of the Ribbon, click Fonts and click the desired font. The colors are provided as a set for different sections and controls: A theme is a combitation of a font and colors. To apply a theme, in the Themes section of the Ribbon, click Themes and select the desired option:
Interface Characteristics of Windows Controls The Visibility of a Windows Control By default, when you add a control to the form or report, that control would appear to the user. For various reasons, you may not want the user to see a certain control. In this case, you can hide that control. The visibility or disappearance of a Windows control can be controlled independently from its corresponding column on a table. To let you control the visibility of a control, the Property Sheet is equipped with the Visible Boolean property. If you set the Visible property to No (the default is Yes, the control would be hidden. The Status Bar of a Form As mentioned for a table, when a control receives focus on a form, you can display some helpful text on the status bar. You can take care of this aspect on the table as we saw already. When the corresponding Windows control on the form receives focus, the same text would display on the status bar of the form. In this case, you must create the Description feature of the field on the table before adding the corresponding control to the form. If you did not create the status bar text in the table, or you created that status bar text after adding the corresponding control to the form, you can still create the text to display on the status bar of the form. To create a status bar text for a field on a form, while in Design View, access the Property Sheet for the control. In the Other or the All tab, enter a sentence in the Status Bar Text property. The Availability of a Control A control is said to be enabled if the user can interact with it. For example, by default, the user can change the text of a text box or make a selection from another type on control. If a control is disabled, the user cannot change its text or change its selection To let you control the availability of an object, the Property Sheet is equipped with a Boolean field named Enabled. Practical Learning: Disabling a Control
Locking a Control A control is said to be locked if the user cannot change the value of the control in Form View. To lock a control, after selecting it in Design View, access its Boolean Locked property in the Property Sheet and set it to Yes (the default value is No). Practical Learning: Locking a Control
How do you select all controls in a report?To select multiple controls, hold down the SHIFT key and then click the controls that you want to remove. To select all of the controls in the layout, click the layout selector box at the top left corner of the layout. Right-click one of the selected controls, point to Layout, and then click Remove Layout.
How can you select all the labels in a report section when working in report Design?To select all controls, in Design View, click in a blank area and then press Ctrl + A.
How do you set a control property in form Design view?In form Design view or report Design view, select the control, section, form, or report for which you want to set the property. You can select: One or more controls. To select multiple controls, hold down the SHIFT key and choose the controls, or drag the mouse pointer over the controls you wish to select.
|