Home Library Learn Samples Downloads Support Community Forums
1 out of 4 rated this helpful - Rate this topic

New Members and Constants

Office 2007

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


Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.