Class Report (Access VBA)

A Report object refers to a particular Microsoft Access report.

The classes Application, Control, Screen and SubForm. give access to class Report

Methods

Circle - The Circle method draws a circle, an ellipse, or an arc on a Report object when the Print event occurs.

Line - The Line method draws lines and rectangles on a Report object when the Print event occurs.

Move - Moves the specified object to the coordinates specified by the argument values.

Print - The Print method prints text on a Report object by using the current color and font.

PSet - The PSet method sets a point on a Report object to a specified color when the Print event occurs.

Requery - The Requery method updates the data underlying the specified report by requerying the source of data for the control.

Scale - The Scale method defines the coordinate system for a Report object.

TextHeight - The TextHeight method returns the height of a text string as it would be printed in the current font of a Report object.

TextWidth - The TextWidth method returns the width of a text string as it would be printed in the current font of a Report object.

Properties

Controls (Default member) - Returns the Controls collection of a form, subform, report, or section.

AllowLayoutView gets or sets whether the specified report can be used in Layout view.

AllowReportView gets or sets whether the user is allowed to enter Report view while using the specified report.

AutoCenter returns or sets a Boolean indicating whether a report will be centered automatically in the application window when the form is opened.

AutoResize returns or sets a Boolean indicating whether a Report window opens automatically sized to display complete records.

BorderStyle specifies how a control's border appears.

Caption gets or sets the title of the report in Print Preview.

CloseButton specifies whether the Close button on a form is enabled.

ControlBox specifies whether a report has a Control menu in Report view.

Count you can use the Count property to determine the number of items in a specified collection.

CurrentRecord you can use the CurrentRecord property to identify the current record in the recordset being viewed.

CurrentView you can use the CurrentView property to determine how a report is currently displayed.

CurrentX you can use the CurrentX property (along with the CurrentY property) to specify the horizontal and vertical coordinates for the starting position of the next printing and drawing method on a report.

CurrentY you can use the CurrentY property (along with the CurrentX property) to specify the horizontal and vertical coordinates for the starting position of the next printing and drawing method on a report.

Cycle you can use the Cycle property to specify what happens when you press the Tab key and the focus is in the last control on a report.

DateGrouping you can use the DateGrouping property to specify how you want to group dates in a report.

DefaultView you can use the DefaultView property to specify the opening view of a report.

DisplayOnSharePointSite gets or sets whether the specified report can be made available as a view on a Microsoft SharePoint Foundation site.

DrawMode you can use the DrawMode property to specify how the pen (the color used in drawing) interacts with existing background colors on a report when the Line, Circle, or Pset method is used to draw on a report when printing.

DrawStyle you can use the DrawStyle property to specify the line style when using the Line and Circle methods to print lines on reports.

DrawWidth you can use the DrawWidth property to specify the line width for the Line, Circle, and Pset methods to print lines on reports.

FastLaserPrinting you can use the FastLaserPrinting property to specify whether lines and rectangles are replaced by text character lines—similar to the underscore ( _ ) and vertical bar ( | ) characters—when you print a report by using most laser printers. Replacing lines and rectangles with text character lines can make printing much faster.

FillColor you use the FillColor property to specify the color that fills in boxes and circles drawn on reports with the Line and Circle methods. You can also use this property with Visual Basic to create special visual effects on custom reports when you print by using a color printer or preview the reports on a color monitor.

FillStyle you can use the FillStyle property to specify whether a circle or line drawn by the Circle or Line method on a report is transparent, opaque, or filled with a pattern.

Filter

FilterOn you can use the FilterOn property to specify or determine whether the Filter property for a form or report is applied.

FilterOnLoad gets or sets whether the filter specified by the Filter property is applied when the report is loaded.

FitToPage gets or sets whether the width of the specified report is sized to automatically fit the page.

FontBold you can use the FontBold property to specify whether a font appears in a bold style in the following situations:.

FontItalic you can use the FontItalic property to specify whether text is italic in the following situations:.

FontName you can use the FontName property to specify the font for text in the following situations:.

FontSize you can use the FontSize property to specify the point size for text in the following situations:.

FontUnderline you can use the FontUnderline property to specify whether text is underlined in the following situations:.

ForeColor you can use the ForeColor property to specify the color for text in a control.

FormatCount you can use the FormatCount property to determine the number of times the OnFormat property has been evaluated for the current section on a report.

GridX you can use the GridX property (along with the GridY property) to specify the horizontal and vertical divisions of the alignment grid in report Design view.

GridY you can use the GridY property (along with the GridX property) to specify the horizontal and vertical divisions of the alignment grid in report Design view.

GroupLevel you can use the GroupLevel property in Visual Basic to refer to the group level that you are grouping or sorting on in a report.

GrpKeepTogether you can use the GrpKeepTogether property to specify whether groups in a multiple column report that have their KeepTogether property for a group set to Whole Group or With First Detail will be kept together by page or by column.

HasData you can use the HasData property to determine if a report is bound to an empty recordset.

HasModule you can use the HasModule property to specify or determine whether a form or report has a class module.

Height gets or sets the height of the specified object in twips.

HelpContextId the HelpContextID property specifies the context ID of a topic in the custom Help file specified by the HelpFile property setting.

HelpFile the name of a help file associated with a report.

Hwnd you can use the hWnd property to determine the handle (a unique Long Integer value) assigned by Windows to the current window.

InputParameters you can use the InputParameters property to specify or determine the input parameters that are passed to a SQL statement in the RecordSource property of a form or report or a stored procedure when used as the record source within a Microsoft Access project (.adp).

KeyPreview you can use the KeyPreview property to specify whether the report-level keyboard event procedures are invoked before a control's keyboard event procedures.

LayoutForPrint you can use the LayoutForPrint property to specify whether the report uses printer or screen fonts.

Left you can use the Left property to specify an object's location on a form or report.

MenuBar specifies a custom menu to display for a report.

MinMaxButtons you can use the MinMaxButtons property to specify whether the Maximize and Minimize buttons will be visible on a report.

Modal you can use the Modal property to specify whether a report opens as a modal window. When a report opens as a modal window, you must close the window before you can move the focus to another object.

Module you can use the Module property to specify a report module.

MouseWheel

Moveable returns or sets a Boolean indicating whether the specified report can be moved by the user; True if it can be moved.

MoveLayout the MoveLayout property specifies whether Microsoft Access should move to the next printing location on the page.

Name you can use the Name property to specify or determine the string expression that identifies the name of an object.

NextRecord the NextRecord property specifies whether a section should advance to the next record.

OnActivate sets or returns the value of the On Activate box in the Properties window of a form or report.

OnApplyFilter sets or returns the value of the On Apply Filter box in the Properties window of a report.

OnClick sets or returns the value of the On Click box in the Properties window.

OnClose sets or returns the value of the On Close box in the Properties window of a form or report.

OnCurrent sets or returns the value of the OnCurrent property on the report.

OnDblClick sets or returns the value of the On Dbl Click box in the Properties window.

OnDeactivate sets or returns the value of the On Deactivate box in the Properties window of a form or report.

OnError sets or returns the value of the On Error box in the Properties window of a form or report.

OnFilter sets or returns the value of the On Filter box in the Properties window of a report.

OnGotFocus sets or returns the value of the On Got Focus box in the Properties window of the specified report.

OnKeyDown sets or returns the value of the On Key Down box in the Properties window.

OnKeyPress sets or returns the value of the On Key Press box in the Properties window.

OnKeyUp sets or returns the value of the On Key Up box in the Properties window.

OnLoad sets or returns the value of the On Load box in the Properties window of a report.

OnLostFocus sets or returns the value of the On Lost Focus box in the Properties window of the specified report.

OnMouseDown sets or returns the value of the On Mouse Down box in the Properties window.

OnMouseMove sets or returns the value of the On Mouse Move box in the Properties window.

OnMouseUp sets or returns the value of the On Mouse Up box in the Properties window.

OnNoData sets or returns the value of the On No Data box in the Properties window of a report.

OnOpen sets or returns the value of the On Open box in the Properties window of a form or report.

OnPage sets or returns the value of the On Page box in the Properties window of a report.

OnResize sets or returns the value of the On Resize box in the Properties window of a report.

OnTimer sets or returns the value of the On Timer box in the Properties window of a form.

OnUnload sets or returns the value of the On Unload box in the Properties window of a form.

OpenArgs determines the string expression specified by the OpenArgs argument of the OpenReport method that opened a report.

OrderBy you can use the OrderBy property to specify how you want to sort records in a report.

OrderByOn you can use the OrderByOn property to specify whether an object's OrderBy property setting is applied.

OrderByOnLoad gets or sets whether the sorting specified by the OrderBy property is applied when the report is loaded.

Orientation you can use the Orientation property to specify or determine the view orientation.

Page

PageFooter you can use the PageFooter property to specify whether a report's page footer is printed on the same page as a report footer.

PageHeader you can use the PageHeader property to specify whether a report's page header is printed on the same page as a report header.

Pages you can use the Pages property to return information needed to print page numbers in a report.

Painting you can use the Painting property to specify whether a report is repainted.

PaintPalette you can use the PaintPalette property to specify a palette to be used by a report.

PaletteSource you can use the PaletteSource property to specify the palette for a report.

Picture you can use the Picture property to specify a bitmap or other type of graphic to be used as a background picture on a report.

PictureAlignment you can use the PictureAlignment property to specify where a background picture will appear in an image control or on a form or report. Read/write Byte.Read/write.

PictureData you can use the PictureData property to copy the picture to another object that supports the Picture property.

PicturePages you can use the PicturePages property to specify on which page or pages of a report a picture will be displayed.

PicturePalette you can use the PicturePalette property to specify a palette to be used by a report.

PictureSizeMode you can use the PictureSizeMode property to specify how a picture for a form or report is sized.

PictureTiling you can use the PictureTiling property to specify whether a background picture is tiled across the entire image control, Form window, form, or page of a report.

PictureType you can use the PictureType property to specify whether Microsoft Access stores an object's picture as a linked or an embedded object.

PopUp specifies whether a report opens as a pop-up window.

PrintCount you can use the PrintCount property to identify the number of times the OnPrint property has been evaluated for the current section of a report.

PrintSection the PrintSection property specifies whether a section should be printed.

Properties returns a reference to a control's Properties collection object.

PrtDevMode you can use the PrtDevMode property to set or return printing device mode information specified for a form or report in the Print dialog box.

PrtDevNames you can use the PrtDevNames property to set or return information about the printer selected in the Print dialog box for a form or report.

PrtMip you can use the PrtMip property in Visual Basic to set or return the device mode information specified for a form or report in the Print dialog box.

RecordLocks you can use the RecordLocks property to determine how records are locked and what happens when two users try to edit the same record at the same time.

Recordset returns or sets the ADO Recordset or DAO Recordset recordset that represents the record source for the specified recordset. Read/write recordset.

RecordSource you can use the RecordSource property to specify the source of the data for a report.

RecordSourceQualifier returns or sets a String indicating the SQL Server owner name of the record source for the specified report.

Report you can use the Report property to refer to a report or to refer to the report associated with a subreport control.

RibbonName gets or sets the name of the customized ribbon to be displayed when the specified report is loaded.

ScaleHeight you can use the ScaleHeight property to specify the number of units for the vertical measurement of the page when the Circle, Line, Pset, or Print method is used while a report is printed or previewed, or its output is saved to a file.

ScaleLeft you can use the ScaleLeft property to specify the units for the horizontal coordinates that describe the location of the left edge of a page when the Circle, Line, Pset, or Print method is used while a report is printed or previewed, or its output is saved to a file.

ScaleMode you can use the ScaleMode property in Visual Basic to specify the unit of measurement for coordinates on a page when the Circle, Line, Pset, or Print method is used while a report is previewed or printed, or its output is saved to a file.

ScaleTop you can use the ScaleTop property to specify the units for the vertical coordinates that describe the location of the top edge of a page when the Circle, Line, Pset, or Print method is used while a report is printed or previewed, or its output is saved to a file.

ScaleWidth you can use the ScaleWidth property to specify the number of units for the horizontal measurement of the page when the Circle, Line, Pset, or Print method is used while a report is printed or previewed, or its output is saved to a file.

ScrollBars gets or sets whether scroll bars appear on a report.

Section you can use the Section property to identify a section of a report and provide access to the properties of that section.

ServerFilter you can use the ServerFilter property to specify a subset of records to be displayed when a server filter is applied to a report within a Microsoft Access project (.adp) or database.

Shape returns a String representing the shape command corresponding to the sorting and grouping of the specified report.

ShortcutMenuBar you can use the ShortcutMenuBar property to specify the shortcut menu that appears when you right-click the specified object.

ShowPageMargins gets or sets whether page margins are displayed when the specified report is in Layout view.

Tag stores extra information about a form, report, section, or control needed by a Microsoft Access application.

TimerInterval you can use the TimerInterval property to specify the interval, in milliseconds, between Timer events on a report.

Toolbar specifies a custom toolbar to display for a report.

Top you can use the Top property to specify an object's location on a form or report.

UseDefaultPrinter returns or sets a Boolean indicating whether the specified report uses the default printer for the system; True if the form or report uses the default printer.

Visible returns or sets whether the object is visible.

Width gets or sets the width of the specified object in twips.

WindowHeight returns the height of a report in twips.

WindowLeft returns an Integer indicating the screen position in twips of the left edge of a report relative to the left edge of the Microsoft Access window.

WindowTop returns an Integer indicating the screen position in twips of the top edge of a report relative to the top of the Microsoft Access window.

WindowWidth returns the width of a report in twips.

Controls - The Controls collection contains all of the controls on a form, report, or subform, within another control, or attached to another control. The Controls collection is a member of the Form, Report, and SubForm objects.

GroupLevel - You can use the GroupLevel property in Visual Basic to refer to the group level that you are grouping or sorting on in a report.

Module - A Module object refers to a standard module or a class module.

Properties - The Properties collection contains all the built-in properties in an instance of an open form, report, or control. These properties uniquely characterize that instance of the object.

Section - A form section is part of a form such as a header, footer, or detail section.