New Members and Constants [Access 2007 Developer Reference]

New Members and Constants

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 spec

Product Families

Resources

About Microsoft

Popular Places

Popular Searches

Popular Downloads

New Members

Application

BoundObjectFrame

CheckBox

CodeProject

ComboBox

CommandButton

Control

CurrentProject

DoCmd

Form

Image

Label

Line

ListBox

ObjectFrame