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.
If you select multiple controls, the property sheet will display only those properties that the selected controls have in common. The entire form or report. Choose the form selector or report selector in the upper-left corner of the form or report.
Display the property sheet by right-clicking the object or section and then choosing Properties on the shortcut menu, or by choosing Properties on the toolbar.
You can also add grouping, sorting, or totals by using the Group, Sort, and Total pane while the report is open in Layout view or Design view:. Click Add a group or Add a sort , and then select the field on which you want to group or sort.
Click More on a grouping or sorting line to set more options and to add totals. For more detailed information about grouping, sorting, and totals, see the article Create a grouped or summary report. Access includes tools for highlighting data on a report. You can add conditional formatting rules for each control or group of controls, and in client reports, you can also add data bars to compare data. Select the required controls and on the Format tab, in the Control Formatting group, click Conditional Formatting.
In the New Formatting Rule dialog box, select a value under Select a rule type :. To create a rule that is evaluated for each record individually, select Check values in the current record or use an expression. To create a rule that compares records to each other by using data bars, click Compare to other records. Under Edit the rule description , specify the rule for when the formatting would be applied as well as what formatting should be applied, and then click OK.
To create an additional rule for the same control or set of controls, repeat this procedure from step 4. Open a report in Layout view by right-clicking it in the Navigation Pane and then clicking Layout V iew. From the Report Layout Tools options, on the Design tab, click Themes and point the cursor over the various themes in the gallery to preview the effects. Click on a theme to select it, and then save your report. Use the Colors or Fonts galleries to set colors or fonts independently.
You can add a logo or background image to a report and If you update the image, the update is automatically made wherever the image is used in the database. On the Format tab, in the Background group, click Background Image. Right-click the report in the Navigation Pane and click Print Preview.
You can use the commands on the Print Preview tab to do any of the following:. Right-click the report in the Navigation Pane and click Print. The report is sent to your default printer. Note: If you select the report in the Navigation Pane and select Print from the File tab, you can select additional printing options such as number of pages and copies and specify a printer.
To open a dialog box where you can select a printer, specify the number of copies, and so on, click Print. Forms and reports. To print rptMyReport to a specific printer, open frmForm1 in Form view, and then click the appropriate button. Skip to main content. This browser is no longer supported.
Download Microsoft Edge More info. Contents Exit focus mode. Please rate your experience Yes No. Any additional feedback? Note rptMyReport represents the actual report that you want to print. If you are not sure of the path or file name, click to open the Picture Builder. Click Browse to find the picture that you want to use or, alternatively, click one of the pictures in the Available Pictures list to preview the professionally-created pictures that you can use.
If you find a picture you want, click OK to add it to the command button. By default, Access sets the Picture Type property to Embedded. When you assign a graphic to a command button's Picture property, using this setting creates a copy of the picture and stores it in the Access database file. Any subsequent changes to the original picture will not be reflected in the command button. To create a link to the original picture so that any changes to the picture will be reflected in the command button, change the Picture Type property to Linked.
You must keep the original picture file in its original location. If you move or rename the picture file, Access displays an error message when you open the database, and the command button displays its caption instead of the picture. Display both a picture and a caption on a command button. Select the command button. If the property sheet is not already displayed, press F4 to display it. On the Format tab of the property sheet, type the caption you want in the Caption property box.
Click the drop-down arrow in the Picture Caption Arrangement property box, and then select the arrangement you want. For example, to display the caption below the picture, select Bottom. To display the caption to the right of the picture, select Right. To make the arrangement dependent on the system locale, select General. By using this setting, the caption will appear on the right for languages that read from left to right, and it will appear on the left for languages that read from right to left.
Forms and reports. Use a command button to start an action or a series of actions. Need more help? Expand your skills. Get new features first.
Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow.
0コメント