New Members and Constants [Access 2007 Developer Reference]

New Members and Constants

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

New Members and Constants

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 Microsoft 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 Microsoft 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 Microsoft 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