New Members and Constants
| Access Developer Reference |
New Members
The following properties, methods, and events have been added to existing objects in Microsoft Office Access 2007.
Application
| Properties | Description |
|---|---|
| Assistance | Returns an IAssistance object that represents the Microsoft Office Help Viewer. Read-only. |
| MacroError | Returns a MacroError object that contains information about the latest error to occur in a macro. Read-only. |
| TempVars | Returns the collection of TempVar objects. Read-only TempVars. |
| Methods | Description |
|---|---|
| ColumnHistory | Gets the history of values that have been stored in a Memo field. |
| ExportNavigationPane | Saves the current configuration of the Navigation Pane to an XML file. |
| HtmlEncode | Converts a string to an HTML-encoded string. |
| ImportNavigationPane | Loads a saved Navigation Pane configuration from disk. |
| LoadCustomUI | Loads XML markup that represents a customized Ribbon. |
| PlainText | Strips the rich text formatting from a string and returns an unformatted text string. |
BoundObjectFrame
| Properties | Description |
|---|---|
| BottomPadding | Gets or sets the amount of space (in inches) between the object frame and its bottom gridline. Read/write Integer. |
| GridlineColor | Gets or sets the color of the gridline for the specified object frame. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified frame. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified frame. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified frame. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified frame. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified frame. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified frame. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified frame. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified frame. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the object frame is anchored horizontally within its layout. Read/write. |
| Layout | Returns the type of layout for the specified object frame. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified object frame. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the object frame and its left gridline. Read/write Integer. |
| RightPadding | Gets or sets the amount of space (in inches) between the object frame and its right gridline. Read/write Integer. |
| TopPadding | Gets or sets the amount of space (in inches) between the object frame and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified object frame is anchored vertically within its layout. Read/write. |
CheckBox
| Properties | Description |
|---|---|
| GridlineColor | Gets or sets the color of the gridline for the specified check box. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified check box. Read/write Byte. |
| BottomPadding | Gets or sets the amount of space (in inches) between the check box and its bottom gridline. Read/write Integer. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified check box. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified check box. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified check box. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified check box. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified check box. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified check box. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified check box. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the check box is anchored horizontally within its layout. Read/write. |
| Layout | Returns the type of layout for the specified check box. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified check box. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the check box and its left gridline. Read/write Integer. |
| RightPadding | Gets or sets the amount of space (in inches) between the check box and its right gridline. Read/write Integer. |
| TopPadding | Gets or sets the amount of space (in inches) between the check box and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified check box is anchored vertically within its layout. Read/write. |
CodeProject
| Properties | Description |
|---|---|
| ImportExportSpecifications | Returns a ImportExportSpecifications collection that represents the collection of saved import or export operations for the specified object. Read-only. |
| IsTrusted | Gets whether or not macros and Visual Basic for Applications (VBA) code have been enabled in the current project. Read-only Boolean. |
ComboBox
| Properties | Description |
|---|---|
| AllowValueListEdits | Gets or sets whether the Edit List Items command is available when the user right-clicks a combo box. Read/write Boolean. |
| BottomMargin | Along with the LeftMargin, RightMargin, and TopMargin properties, specifies the location of information displayed within a text box control. Read/write Integer. |
| BottomPadding | Gets or sets the amount of space (in inches) between the combo box and its bottom gridline. Read/write Integer. |
| CanGrow | Gets or sets whether the specified control automatically adjusts vertically to print or preview all the data the control contains. Read/write Boolean. |
| CanShrink | Gets or sets whether the specified control automatically adjusts vertically to print or preview all the data the control contains. Read/write Boolean. |
| DisplayAsHyperlink | Gets or sets an AcDisplayAsHyperlink constant that specifies whether to display the contents of the specified combo box as a hyperlink. Read/write. |
| Layout | Returns the type of layout for the specified combo box. Read-only AcLayoutType. |
| GridlineColor | Gets or sets the color of the gridline for the specified combo box. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified combo box. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified combo box. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified combo box. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified combo box. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified combo box. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified combo box. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified combo box. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified combo box. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the combo box is anchored horizontally within its layout. Read/write. |
| InheritValueList | Gets or sets whether a combo box's value list is inherited from its field. Read/write Boolean. |
| ItemsSelected | You can use the ItemsSelected property to return a read-only reference to the hidden ItemsSelected collection. This hidden collection can be used to access data in the selected rows of a multiselect combo box control. |
| LayoutID | Returns the unique identifier for the layout that contains the specified combo box. Read-only Long. |
| LeftMargin | Along with the TopMargin, RightMargin, and BottomMargin properties, specifies the location of information displayed within a text box control. Read/write Integer. |
| LeftPadding | Gets or sets the amount of space (in inches) between the combo box and its left gridline. Read/write Integer. |
| ListItemsEditForm | Gets or sets the name of the form that is displayed when the user clicks Edit List Items. Read/write String. |
| RightMargin | Along with the TopMargin, Left Margin, and BottomMargin properties, specifies the location of information displayed within a combo box control. Read/write Integer. |
| RightPadding | Gets or sets the amount of space (in inches) between the combo box and its right gridline. Read/write Integer. |
| Selected | You can use the Selected property in Visual Basic to determine if an item in a combo box is selected. Read/write Long. |
| SeparatorCharacters | Gets or sets the separator displayed between values when the combo box is bound to a multi-valued field. Read/write AcSeparatorCharacters. |
| ShowOnlyRowSourceValues | Gets or sets whether the combo box can display values that aren't specified by the RowSource property. Read/write Boolean. |
| TopMargin | Along with the LeftMargin, RightMargin, and BottomMargin properties, specifies the location of information displayed within a text box control. Read/write Integer. |
| TopPadding | Gets or sets the amount of space (in inches) between the combo box and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified combo box is anchored vertically within its layout. Read/write. |
CommandButton
| Properties | Description |
|---|---|
| Alignment | |
| BackStyle | You can use the BackStyle property to specify whether a control will be transparent. Read/write Byte. |
| BottomPadding | Gets or sets the amount of space (in inches) between the button and its bottom gridline. Read/write Integer. |
| CursorOnHover | Gets or sets the type of mouse cursor displayed when the user rests the pointer on a button. Read/write AcCursorOnHover. |
| GridlineColor | Gets or sets the color of the gridline for the specified command button. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified button. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified button. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified button. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified button. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified button. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified button. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified button. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified button. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the button is anchored horizontally within its layout. Read/write. |
| Layout | Returns the type of layout for the specified button. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified button. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the button and its left gridline. Read/write Integer. |
| PictureCaptionArrangement | |
| RightPadding | Gets or sets the amount of space (in inches) between the button and its right gridline. Read/write Integer. |
| TopPadding | Gets or sets the amount of space (in inches) between the button and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified button is anchored vertically within its layout. Read/write. |
Control
| Properties | Description |
|---|---|
| BottomPadding | Gets or sets the amount of space (in inches) between the control and its bottom gridline. Read/write Integer. |
| GridlineColor | Gets or sets the color of the gridline for the specified control. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified control. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified control. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified control. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified control. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified control. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified control. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified control. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified control. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the control is anchored horizontally within its layout. Read/write. |
| Layout | Returns the type of layout for the specified control. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified control. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the control and its left gridline. Read/write Integer. |
| Name | You can use the Name property to determine the string expression that identifies the name of an object. Read-only String. |
| RightPadding | Gets or sets the amount of space (in inches) between the control and its right gridline. Read/write Integer. |
| TopPadding | Gets or sets the amount of space (in inches) between the control and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified control is anchored vertically within its layout. Read/write. |
CurrentProject
| Properties | Description |
|---|---|
| ImportExportSpecifications | Returns a ImportExportSpecifications collection that represents the collection of saved import or export operations for the specified object. Read-only. |
| IsTrusted | Gets whether or not macros and Visual Basic for Applications (VBA) code have been enabled in the current project. Read-only Boolean. |
DoCmd
| Methods | Description |
|---|---|
| ClearMacroError | Removes information about an error that is stored in the MacroError object. |
| CloseDatabase | Closes the current database. |
| LockNavigationPane | You can use the LockNavigationPane action to prevent users from deleting database objects that are displayed in the Navigation Pane. |
| NavigateTo | You can use the NavigateTo method to control the display of database objects in the Navigation Pane. |
| RunSavedImportExport | Rrun a saved import or export specification. |
| SearchForRecord | You can use the SearchForRecord method to search for a specific record in a table, query, form, or report. |
| SetDisplayedCategories | Specifies which categories are displayed under Navigate to Category in the title bar of the Navigation Pane. |
| SetProperty | The SetProperty method carries out the SetProperty action in Visual Basic. |
| SingleStep | Pauses macro execution and opens the Macro Single Step dialog box. |
| TransferSharePointList | You can use the TransferSharePointList method to import or link data from a Windows SharePoint Services 3.0 site. |
Form
| Properties | Description |
|---|---|
| AllowLayoutView | Gets or sets whether the specified form can be used in Layout View. Read/write Boolean. |
| DatasheetAlternateBackColor | Gets or sets the color displayed on alternate rows of a form's datasheet. Read/write Long. |
| DisplayOnSharePointSite | Gets or sets whether the specified form can be made available as a view on a Windows SharePoint Services 3.0 site. Read/write Byte. |
| FilterOnLoad | Gets or sets whether the filter specified by the Filter property is applied when the form is loaded. Read/write Boolean. |
| FitToScreen | Gets or sets whether the width of the form is reduced to fit the width of the screen. Read/write Boolean. |
| NavigationCaption | Gets or sets the text that appears to the left of the form's navigation buttons. Read/write String. |
| OrderByOnLoad | Gets or sets whether the sorting specified by the OrderBy property is applied when the report is loaded. Read/write Boolean. |
| RibbonName | Gets or set the name of the customized Ribbon to be displayed when the specified form is loaded. Read/write String. |
| SplitFormDatasheet | Gets or sets whether the user can edit records in the datasheet when a form is displayed in Split Form view. Read/write AcSplitFormDatasheet. |
| SplitFormOrientation | Gets or sets the position of the datasheet relative to the form when the form is displayed in Split Form view. Read/write AcSplitFormOrientation. |
| SplitFormPrinting | Gets or sets whether the contents of the form or the datasheet are printed when printing a form displayed in Split Form view. Read/write AcSplitFormPrinting. |
| SplitFormSize | Gets or sets the size in twips of the form when it's displayed in Split Form view. Read/write Long. |
| SplitFormSplitterBar | Gets or sets whether the splitter bar is available when the form is displayed in Split Form mode. Read/write Boolean. |
| SplitFormSplitterBarSave | Gets or sets whether the location of the splitter bar is saved when a form that's displayed in Split Form mode is closed. Read/write Boolean. |
Image
| Properties | Description |
|---|---|
| BottomPadding | Gets or sets the amount of space (in inches) between the image control and its bottom gridline. Read/write Integer. |
| GridlineColor | Gets or sets the color of the gridline for the specified image control. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified image control. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified image. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified image control. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified image control. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified image control. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified image control. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified image control. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified image control. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the image is anchored horizontally within its layout. Read/write. |
| Layout | Returns the type of layout for the specified image. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified image. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the image control and its left gridline. Read/write Integer. |
| RightPadding | Gets or sets the amount of space (in inches) between the image control and its right gridline. Read/write Integer. |
| TabIndex | You can use the TabIndex property to specify a control's place in the tab order on a form. Read/write Integer. |
| TabStop | You can use the TabStop property to specify whether you can use the TAB key to move the focus to a control in Form view. Read/write Boolean. |
| TopPadding | Gets or sets the amount of space (in inches) between the image control and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified image is anchored vertically within its layout. Read/write. |
Label
| Properties | Description |
|---|---|
| BottomPadding | Gets or sets the amount of space (in inches) between the label and its bottom gridline. Read/write Integer. |
| GridlineColor | Gets or sets the color of the gridline for the specified label. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified label. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified label. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified label. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified label. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified label. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified label. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified label. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified label. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the label is anchored horizontally within its layout. Read/write. |
| Layout | Returns the type of layout for the specified label. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified label. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the label and its left gridline. Read/write Integer. |
| RightPadding | Gets or sets the amount of space (in inches) between the label and its right gridline. Read/write Integer. |
| TopPadding | Gets or sets the amount of space (in inches) between the label and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified label is anchored vertically within its layout. Read/write. |
Line
| Properties | Description |
|---|---|
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the line is anchored horizontally within its layout. Read/write. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified line is anchored vertically within its layout. Read/write. |
ListBox
| Properties | Description |
|---|---|
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified list box. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified list box. Read/write Byte. |
| AllowValueListEdits | Gets or sets whether the Edit List Items command is available when the user right-clicks a list box. Read/write Boolean. |
| BottomPadding | Gets or sets the amount of space (in inches) between the list box and its bottom gridline. Read/write Integer. |
| GridlineColor | Gets or sets the color of the gridline for the specified list box. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified list box. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified list box. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified list box. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified list box. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified list box. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified list box. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the list box is anchored horizontally within its layout. Read/write. |
| InheritValueList | Gets or sets whether a list box's value list is inherited from its field. Read/write Boolean. |
| Layout | Returns the type of layout for the specified list box. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified list box. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the list box and its left gridline. Read/write Integer. |
| ListItemsEditForm | Gets or sets the name of the form that is displayed when the user clicks Edit List Items. Read/write String. |
| RightPadding | Gets or sets the amount of space (in inches) between the list box and its right gridline. Read/write Integer. |
| ShowOnlyRowSourceValues | Gets or sets whether the list box can display values that aren't specified by the RowSource property. Read/write Boolean. |
| TopPadding | Gets or sets the amount of space (in inches) between the list box and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified list box is anchored vertically within its layout. Read/write. |
ObjectFrame
| Properties | Description |
|---|---|
| BottomPadding | Gets or sets the amount of space (in inches) between the object frame and its bottom gridline. Read/write Integer. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified frame. Read/write Byte. |
| GridlineColor | Gets or sets the color of the gridline for the specified object frame. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified frame. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified frame. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified frame. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified frame. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified frame. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified frame. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified frame. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the object frame is anchored horizontally within its layout. Read/write. |
| Layout | Returns the type of layout for the specified object frame. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified object frame. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the object frame and its left gridline. Read/write Integer. |
| RightPadding | Gets or sets the amount of space (in inches) between the object frame and its right gridline. Read/write Integer. |
| TopPadding | Gets or sets the amount of space (in inches) between the object frame and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified object frame is anchored vertically within its layout. Read/write. |
OptionButton
| Properties | Description |
|---|---|
| BottomPadding | Gets or sets the amount of space (in inches) between the option button and its bottom gridline. Read/write Integer. |
| GridlineColor | Gets or sets the color of the gridline for the specified option button. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified option button. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified option button. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified option button. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified option button. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified option button. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified option button. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified option button. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified option button. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the option button is anchored horizontally within its layout. Read/write. |
| Layout | Returns the type of layout for the specified option button. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified option button. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the option button and its left gridline. Read/write Integer. |
| RightPadding | Gets or sets the amount of space (in inches) between the option button and its right gridline. Read/write Integer. |
| TopPadding | Gets or sets the amount of space (in inches) between the option button and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified option button is anchored vertically within its layout. Read/write. |
OptionGroup
| Properties | Description |
|---|---|
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the option group is anchored horizontally within its layout. Read/write. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified option group is anchored vertically within its layout. Read/write. |
Rectangle
| Properties | Description |
|---|---|
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the rectangle is anchored horizontally within its layout. Read/write. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified rectangle is anchored vertically within its layout. Read/write. |
Report
| Properties | Description |
|---|---|
| AllowLayoutView | Gets or sets whether the specified report can be used in Layout View. Read/write Boolean. |
| AllowReportView | Gets or sets whether the user is allowed to enter Report view while using the specified report. Read/write Boolean. |
| CurrentView | You can use the CurrentView property to determine how a report is currently displayed. Read/write Integer. |
| 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. Read/write Byte. |
| DefaultView | You can use the DefaultView property to specify the opening view of a report. Read/write Byte. |
| DisplayOnSharePointSite | Gets or sets whether the specified report can be made available as a view on a Windows SharePoint Services 3.0 site. Read/write Byte. |
| FilterOnLoad | Gets or sets whether the filter specified by the Filter property is applied when the report is loaded. Read/write Boolean. |
| FitToPage | Gets or sets whether the width of the specified report is sized to automatically fit the page. Read/write Boolean. |
| MouseWheel | Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the MouseWheel event occurs. Read/write. |
| 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. Read/write Boolean. |
| OnApplyFilter | Sets or returns the value of the On Apply Filter box in the Properties window of a report. Read/write String. |
| OnClick | Sets or returns the value of the On Click box in the Properties window. Read/write String. |
| OnCurrent | Sets or returns the value of the On Current box in the Properties window of a report. Read/write String. |
| OnDblClick | Sets or returns the value of the On Dbl Click box in the Properties window. Read/write String. |
| OnFilter | Sets or returns the value of the On Filter box in the Properties window of a report. Read/write String. |
| OnGotFocus | Sets or returns the value of the On Got Focus box in the Properties window of the specified report. Read/write String. |
| OnKeyDown | Sets or returns the value of the On Key Down box in the Properties window. Read/write String. |
| OnKeyPress | Sets or returns the value of the On Key Press box in the Properties window. Read/write String. |
| OnKeyUp | Sets or returns the value of the On Key Up box in the Properties window. Read/write String. |
| OnLoad | Sets or returns the value of the On Load box in the Properties window of a report. Read/write String. |
| OnLostFocus | Sets or returns the value of the On Lost Focus box in the Properties window of the specified report. Read/write String. |
| OnMouseDown | Sets or returns the value of the On Mouse Down box in the Properties window. Read/write String. |
| OnMouseMove | Sets or returns the value of the On Mouse Move box in the Properties window. Read/write String. |
| OnMouseUp | Sets or returns the value of the On Mouse Up box in the Properties window. Read/write String. |
| OnResize | Sets or returns the value of the On Resize box in the Properties window of a form. Read/write String. |
| OnTimer | Sets or returns the value of the On Timer box in the Properties window of a form. Read/write String. |
| OnUnload | Sets or returns the value of the On Unload box in the Properties window of a form. Read/write String. |
| OrderByOnLoad | Gets or sets whether the sorting specified by the OrderBy property is applied when the report is loaded. Read/write Boolean. |
| RibbonName | Gets or set the name of the customized Ribbon to be displayed when the specified report is loaded. Read/write String. |
| ScrollBars | Gets or sets whether scroll bars appear on a report. Read/write Byte. |
| ShowPageMargins | Gets or sets whether page margins are displayed when the specified report is in Layout view. Read/write Boolean. |
| TimerInterval | You can use the TimerInterval property to specify the interval, in milliseconds, between Timer events on a report. Read/write Long. |
| Methods | Description |
|---|---|
| Requery | The Requery method updates the data underlying the specified report by requerying the source of data for the control. |
| Events | Description |
|---|---|
| ApplyFilter | Occurs when a filter is applied to a report. |
| MouseMove | The MouseMove event occurs when the user moves the mouse. |
| Click | The Click event occurs when the user presses and then releases a mouse button over a report. |
| Current | Occurs when the focus moves to a record, making it the current record, or when the report is refreshed or requeried. |
| DblClick | The DblClick event occurs when the user presses and releases the left mouse button twice over an report within the double-click time limit of the system. |
| Filter | Occurs when the user opens a filter window by clicking Advanced Filter/Sort. |
| MouseUp | The MouseUp event occurs when the user releases a mouse button. |
| GotFocus | The GotFocus event occurs when the report receives the focus. |
| MouseWheel | Occurs when the user rolls the mouse wheel in Report view or Layout view. |
| KeyDown | The KeyDown event occurs when the user presses a key while a report has the focus. This event also occurs if you send a keystroke to a report by using the SendKeys action in a macro or the SendKeys statement in Visual Basic. |
| KeyPress | The KeyPress event occurs when the user presses and releases a key or key combination that corresponds to an ANSI code while a report has the focus. This event also occurs if you send an ANSI keystroke to a report by using the SendKeys action in a macro or the SendKeys statement in Visual Basic. |
| KeyUp | The KeyUp event occurs when the user releases a key while a report has the focus. This event also occurs if you send a keystroke to a report by using the SendKeys action in a macro or the SendKeys statement in Visual Basic. |
| Load | Occurs when a report is opened and its records are displayed. |
| LostFocus | The LostFocus event occurs when the specified object loses the focus. |
| MouseDown | The MouseDown event occurs when the user presses a mouse button. |
| Resize | The Resize event occurs when a report is opened and whenever the size of a report changes. |
| Timer | The Timer event occurs for a report at regular intervals as specified by the report's TimerInterval property. |
| Unload | The Unload event occurs after a report is closed but before it's removed from the screen. |
Section
| Properties | Description |
|---|---|
| AlternateBackColor | Gets or sets the background color to display on alternate rows of the specified section. Read/write Long. |
| AutoHeight | Gets or sets whether a section's height is adjusted automatically when controls are resized. Read/write Boolean. |
| OnPaint | Sets or returns the value of the On Paint box in the Properties window of a form or report. Read/write String. |
| Events | Description |
|---|---|
| Paint | Occurs when the specified section is redrawn. |
SubForm
| Properties | Description |
|---|---|
| BottomPadding | Gets or sets the amount of space (in inches) between the subform and its bottom gridline. Read/write Integer. |
| FilterOnEmptyMaster | Gets or sets whether all records are displayed when the subform's master field is Null. Read/write Boolean. |
| GridlineColor | Gets or sets the color of the gridline for the specified subform. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified subform. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified subform. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified subform. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified subform. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified subform. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified subform. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified subform. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified subform. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the subform is anchored horizontally within its layout. Read/write. |
| Layout | Returns the type of layout for the specified subform. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified subform. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the subform and its left gridline. Read/write Integer. |
| RightPadding | Gets or sets the amount of space (in inches) between the subform and its right gridline. Read/write Integer. |
| TopPadding | Gets or sets the amount of space (in inches) between the subform and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified subform is anchored vertically within its layout. Read/write. |
TabControl
| Properties | Description |
|---|---|
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the tab control is anchored horizontally within its layout. Read/write. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified tab control is anchored vertically within its layout. Read/write. |
TextBox
| Properties | Description |
|---|---|
| BottomPadding | Gets or sets the amount of space (in inches) between the text box and its bottom gridline. Read/write Integer. |
| DisplayAsHyperlink | Gets or sets an AcDisplayAsHyperlink constant that specifies whether to display the contents of the specified text box as a hyperlink. Read/write. |
| GridlineColor | Gets or sets the color of the gridline for the specified text box. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified text box. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified text box. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified text box. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified text box. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified text box. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified text box. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified text box. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified text box. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the text box is anchored horizontally within its layout. Read/write. |
| Layout | Returns the type of layout for the specified text box. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified text box. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the text box and its left gridline. Read/write Integer. |
| RightPadding | Gets or sets the amount of space (in inches) between the text box and its right gridline. Read/write Integer. |
| ShowDatePicker | |
| TextFormat | Gets or sets whether rich text is displayed in the specified text box. Read/write AcTextFormat. |
| TopPadding | Gets or sets the amount of space (in inches) between the text box and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified text box is anchored vertically within its layout. Read/write. |
ToggleButton
| Properties | Description |
|---|---|
| BottomPadding | Gets or sets the amount of space (in inches) between the toggle button and its bottom gridline. Read/write Integer. |
| GridlineColor | Gets or sets the color of the gridline for the specified toggle button. Read/write Long. |
| GridlineStyleBottom | Gets or sets the bottom gridline style of the specified toggle button. Read/write Byte. |
| GridlineStyleLeft | Gets or sets the width of the bottom gridline for the specified toggle button. Read/write Byte. |
| GridlineStyleRight | Gets or sets the right gridline style of the specified toggle button. Read/write Byte. |
| GridlineStyleTop | Gets or sets the top gridline style of the specified toggle button. Read/write Byte. |
| GridlineWidthBottom | Gets or sets the width of the bottom gridline for the specified toggle button. Read/write Byte. |
| GridlineWidthLeft | Gets or sets the width of the left gridline for the specified toggle button. Read/write Byte. |
| GridlineWidthRight | Gets or sets the width of the right gridline for the specified toggle button. Read/write Byte. |
| GridlineWidthTop | Gets or sets the width of the top gridline for the specified toggle button. Read/write Byte. |
| HorizontalAnchor | Gets or sets an AcHorizontalAnchor constant that indicates how the toggle button is anchored horizontally within its layout. Read/write. |
| Layout | Returns the type of layout for the specified toggle button. Read-only AcLayoutType. |
| LayoutID | Returns the unique identifier for the layout that contains the specified toggle button. Read-only Long. |
| LeftPadding | Gets or sets the amount of space (in inches) between the toggle button and its left gridline. Read/write Integer. |
| RightPadding | Gets or sets the amount of space (in inches) between the toggle button and its right gridline. Read/write Integer. |
| TopPadding | Gets or sets the amount of space (in inches) between the toggle button and its top gridline. Read/write Integer. |
| VerticalAnchor | Gets or sets an AcVerticalAnchor constant that indicates how the specified toggle button is anchored vertically within its layout. Read/write. |
New Constants
The following constants have been added to existing enumerations in Microsoft Office Access 2007.
| Enumeration | New Constants |
|---|---|
| AcCommand | acCmdAddFromOutlook acCmdAnchorBottomLeft acCmdAnchorBottomRight acCmdAnchorBottomStretchAcross acCmdAnchorStretchAcross acCmdAnchorStretchDown acCmdAnchorStretchDownAcross acCmdAnchorStretchDownRight acCmdAnchorTopLeft acCmdAnchorTopRight acCmdApplyAutoFormat1 acCmdApplyAutoFormat10 acCmdApplyAutoFormat11 acCmdApplyAutoFormat12 acCmdApplyAutoFormat13 acCmdApplyAutoFormat14 acCmdApplyAutoFormat15 acCmdApplyAutoFormat16 acCmdApplyAutoFormat17 acCmdApplyAutoFormat18 acCmdApplyAutoFormat19 acCmdApplyAutoFormat2 acCmdApplyAutoFormat20 acCmdApplyAutoFormat21 acCmdApplyAutoFormat22 acCmdApplyAutoFormat23 acCmdApplyAutoFormat24 acCmdApplyAutoFormat25 acCmdApplyAutoFormat3 acCmdApplyAutoFormat4 acCmdApplyAutoFormat5 acCmdApplyAutoFormat6 acCmdApplyAutoFormat7 acCmdApplyAutoFormat8 acCmdApplyAutoFormat9 acCmdBrowseSharePointList acCmdCloseAll acCmdCloseDatabase acCmdCollectDataViaEmail acCmdControlMarginsMedium acCmdControlMarginsNarrow acCmdControlMarginsNone acCmdControlMarginsWide acCmdControlPaddingMedium acCmdControlPaddingNarrow acCmdControlPaddingNone acCmdControlPaddingWide acCmdDeleteSharePointList acCmdDiscardChanges acCmdDiscardChangesAndRefresh acCmdEditListItems acCmdExportAccess acCmdExportdBase acCmdExportExcel acCmdExportFixedFormat acCmdExportHTML acCmdExportLotus acCmdExportODBC acCmdExportParadox acCmdExportRTF acCmdExportSharePointList acCmdExportSnapShot acCmdExportText acCmdExportXML acCmdFieldTemplates acCmdFilterMenu acCmdHideMessageBar acCmdImportAttachAccess acCmdImportAttachdBase acCmdImportAttachExcel acCmdImportAttachHTML acCmdImportAttachLotus acCmdImportAttachODBC acCmdImportAttachOutlook acCmdImportAttachParadox acCmdImportAttachSharePointList acCmdImportAttachText acCmdImportAttachXML acCmdInsertLogo acCmdInsertTitle acCmdLayoutGridlinesBoth acCmdLayoutGridlinesBottom acCmdLayoutGridlinesCrossHatch acCmdLayoutGridlinesHorizontal acCmdLayoutGridlinesNone acCmdLayoutGridlinesOutline acCmdLayoutGridlinesTop acCmdLayoutGridlinesVertical acCmdLayoutView acCmdMacroAllActions acCmdMacroArguments acCmdManageAttachments acCmdManageReplies acCmdModifySharePointList acCmdModifySharePointListAlerts acCmdModifySharePointListPermissions acCmdModifySharePointListWorkflow acCmdMoveColumnCellDown acCmdMoveColumnCellUp acCmdNewObjectBlankForm acCmdNewObjectBlankReport acCmdNewObjectContinuousForm acCmdNewObjectDatasheetForm acCmdNewObjectDesignForm acCmdNewObjectDesignQuery acCmdNewObjectDesignReport acCmdNewObjectDesignTable acCmdNewObjectLabelsReport acCmdNewObjectModalForm acCmdNewObjectPivotChart acCmdNewObjectPivotTable acCmdNewObjectSplitForm acCmdPasteFormatting acCmdPrintSelection acCmdPublishDatabase acCmdPublishFixedFormat acCmdRefreshData acCmdRefreshSharePointList acCmdRemoveAllFilters acCmdRemoveAllSorts acCmdRemoveFilterFromCurrentColumn acCmdRemoveFromLayout acCmdReportView acCmdSaveAsOutlookContact acCmdSavedExports acCmdSavedImports acCmdSelectEntireColumn acCmdSelectEntireRow acCmdSetCaption acCmdShareOnSharePoint acCmdSharePointSiteRecycleBin acCmdShowColumnHistory acCmdShowDatePicker acCmdShowMessageBar acCmdStackedLayout acCmdStartNewWorkflow acCmdSynchronize acCmdTabularLayout acCmdToggleCacheListData acCmdToggleOffline acCmdWorkflowTasks |
| AcControlType | acAttachment |
| AcCurrentView | acCurViewLayout acCurViewReportBrowse |
| AcDataObjectType | acDataReport |
| AcDefView | acDefViewSplitForm |
| AcExportXMLOtherFlags | acExportAllTableAndFieldProperties |
| AcFileFormat | acFileFormatAccess2007 |
| AcFormView | acLayout |
| AcSpreadSheetType | acSpreadsheetTypeExcel12 acSpreadsheetTypeExcel12Xml |
| AcView | acViewLayout acViewReport |