Properties Reference

See Also

The following reference groups all properties by object or collection and lists them alphabetically. An asterisk (*) indicates that the property was added for Microsoft Access 2000.

Grouped by Object or Collection

AccessObject* Err (VBA)
AccessObjectProperties* Error (ADO)
AccessObjectProperty* Errors (ADO)
AllDataAccessPages* Error, Errors (DAO)
AllDatabaseDiagrams* Field (ADO)
AllForms* Field, Fields (DAO)
AllMacros* Fields (ADO)
AllModules* FileSearch*
AllQueries* Form
AllReports* Forms
AllStoredProcedures* Group, Groups (DAO)
AllTables* Index
AllViews* Index, Indexes (DAO)
AnswerWizard LanguageSettings*
Application Module
Assistant Modules
CodeData* Parameter, Parameters (DAO)
CodeProject* Parameters (ADO)
Collection (VBA) Properties
ComAddIns* Property, Properties (DAO)
Command (ADO) Query
CommandBars QueryDef, QueryDefs (DAO)
Connection (ADO) Recordset (ADO)
Connection, Connections (DAO) Recordset, Recordsets (DAO)
Container, Containers (DAO) Reference
Control References
Controls Relation, Relations (DAO)
CurrentData* Report
CurrentProject* Reports
DataAccessPages* Screen
DataAccessPage* Table
Database, Databases (DAO) TableDef, TableDefs (DAO)
DBEngine (DAO) User, Users (DAO)
Debug (VBA) VBE * (VBA)
DefaultWebOptions* WebOptions*
DoCmd Workspace, Workspaces (DAO)
Document, Documents (DAO)  

Listed Alphabetically

A

AbsolutePage (ADO) AllowEdits
AbsolutePosition (ADO) AllowFilters
AbsolutePosition (DAO) AllowFullMenus
Action AllowShortcutMenus
ActiveCommand (ADO) AllowSpecialKeys
ActiveConnection (ADO) AllowToolbarChanges
ActiveControl AllowZeroLength (DAO)
ActiveDatasheet AllowZeroLength
ActiveForm AllPermissions (DAO)
ActiveReport AppIcon
ActualSize (ADO) Application
AddColon AppTitle
AfterDelConfirm Assistant
AfterInsert Attributes (ADO)
AfterUpdate Attributes (DAO)
Alias AutoActivate
AllowAdditions AutoCenter
AllowAutoCorrect AutoExpand
AllowBreakIntoCode AutoLabel
AllowBuiltInToolbars AutoRepeat
AllowBypassKey AutoResize
AllowDeletions AutoTab

B

BackColor Bookmark
BackStyle Bookmark (ADO)
BatchCollisionCount (DAO) Bookmark (DAO)
BatchCollisions (DAO) Bookmarkable (DAO)
BatchSize (DAO) BorderColor
BeforeDelConfirm BorderStyle
BeforeInsert BorderWidth
BeforeUpdate BoundColumn
BOF (ADO) BuiltIn
BOF (DAO)  

C

CacheSize (ADO) Connection (DAO)
CacheSize (DAO) ConnectionString (ADO)
CacheStart (DAO) ConnectionTimeout (ADO)
Cancel Container (DAO)
CanGrow ControlBox
CanShrink ControlSource
Caption ControlTipText
Class ControlType
CloseButton Count (ADO)
Clustered (DAO) Count (DAO)
CodeContextObject Count (VBA)
CollatingOrder (DAO) Count
Column CountOfDeclarationLines
ColumnCount CountOfLines
ColumnHeadings CurrentObjectName
ColumnHeads CurrentObjectType
ColumnHidden CurrentRecord
ColumnOrder CurrentSectionLeft
ColumnWidth CurrentSectionTop
ColumnWidths CurrentView
CommandBars CurrentX
CommandText (ADO) CurrentY
CommandTimeout (ADO) CursorLocation (ADO)
CommandType (ADO) CursorType (ADO)
ConflictTable (DAO) Cycle
Connect (DAO)  

D

Database Properties DefaultUser (DAO)
Database (DAO) DefaultValue (DAO)
DataEntry DefaultValue
DataMember (ADO) DefaultView
DatasheetBackColor DefinedSize (ADO)
DatasheetCellsEffect Description
DatasheetFontHeight Description (ADO)
DatasheetFontItalic Description (DAO)
DatasheetFontName Description (VBA)
DatasheetFontUnderline DesignMasterID (DAO)
DatasheetFontWeight DestConnectStr
DatasheetForeColor DestinationDB
DatasheetGridLinesBehavior DestinationTable
DatasheetGridLinesColor Direction (ADO)
DataSource (ADO) Direction (DAO)
DataType Dirty
DataUpdatable (DAO) DisplayControl
DateCreated (DAO) DisplayType
DateGrouping DisplayWhen
DBEngine DistinctCount (DAO)
DecimalPlaces DividingLines
Default DrawMode
DefaultCursorDriver (DAO) DrawStyle
DefaultDatabase (ADO) DrawWidth
DefaultType (DAO)  

E–F

EditMode (ADO) FontItalic
EditMode (DAO) FontName
Enabled FontSize
EnterKeyBehavior FontUnderline
EOF (ADO) FontWeight
EOF (DAO) ForceNewPage
EventProcPrefix ForeColor
FailOnError Foreign (DAO)
FastLaserPrinting ForeignName (DAO)
FieldName ForeignTable (DAO)
FieldSize (DAO) Form
FieldSize Format
FillColor Format — Date/Time Data Type
FillStyle Format — Number and Currency Data Types
Filter (ADO) Format — Text and Memo Data Types
Filter (DAO) Format — Yes/No Data Type
Filter FormatCount
FilterLookup FrozenColumns
FilterOn FullPath
FontBold  

G–H

GridX HelpContext (ADO)
GridY HelpContext (DAO)
GroupFooter HelpContext (VBA)
GroupHeader HelpContextID
GroupInterval HelpFile (ADO)
GroupLevel HelpFile (DAO)
GroupOn HelpFile
GrpKeepTogether HideDuplicates
GUID HWnd
HasContinued Hyperlink
HasData HyperlinkAddress
HasModule HyperlinkSubAddress
Height  

I–K

IgnoreNulls (DAO) IsBroken
IgnoreNulls IsolateODBCTrans (DAO)
ImageHeight IsolationLevel (ADO)
ImageWidth IsVisible
Index (ADO) Item (ObjectFrame Control)
Index (DAO) Item (Collections)
Indexed ItemData
Inherit (DAO) KeepLocal (DAO)
Inherited (DAO) KeepTogether — Groups
IniPath (DAO) KeepTogether — Sections
InputMask KeyPreview
InSelection Kind
InsideHeight  
InsideWidth  

L

LabelAlign LinkMasterFields
LabelX ListCount
LabelY ListIndex
LastDLLError (VBA) ListRows
LastModified (DAO) ListWidth
LastUpdated (DAO) Locked
LayoutForPrint LockEdits (DAO)
Left LockType (ADO)
LimitToList LoginTimeout (DAO)
Lines LogMessages (DAO)
LineSlant LogMessages
LinkChildFields LpOLEObject

M–N

Major MultiRow
MarshalOptions (ADO) MultiSelect
MaxRecords Name (ADO)
MaxRecords (ADO) Name (DAO)
MaxRecords (DAO) Name
MDE NativeError (ADO)
Me NavigationButtons
MenuBar NewRecord
MinMaxButtons NewRowOrCol
Minor NewValues
Modal NoMatch (DAO)
Mode (ADO) Number (ADO)
Module Number (DAO)
MousePointer Number (VBA)
MoveLayout NumericScale (ADO)

O

Object Properties OnFormat
Object OnLostFocus
ObjectPalette OnMouseDown
ObjectVerbs OnMouseMove
ObjectVerbsCount OnMouseUp
ODBCConnectStr OnNoData
ODBCTimeout (DAO) OnNotInList
ODBCTimeout OnOpen
OldValue OnPage
OLEClass OnPrint
OLEData OnResize
OLEType OnRetreat
OLETypeAllowed OnTimer
OnActivate OnUnload
OnChange OnUpdated
OnClick OpenArgs
OnClose OptionValue
OnCurrent OrderBy
OnDblClick OrderByOn
OnDeactivate OrdinalPosition (DAO)
OnDelete OriginalValue (ADO)
OnEnter OriginalValue (DAO)
OnError OutputAllFields
OnExit Owner (DAO)

P

Page PictureType
PageCount (ADO) PID (DAO)
PageFooter PopUp
PageHeader Precision (ADO)
PageIndex Prepare (DAO)
Pages Prepared (ADO)
PageSize (ADO) PreviousControl
Painting Primary (DAO)
PaintPalette Primary
PaletteSource PrintCount
Parent PrintSection
PartialReplica (DAO) ProcBodyLine
Password (DAO) ProcCountLines
PercentPosition (DAO) ProcOfLine
Permissions (DAO) ProcStartLine
Picture ProjectName
PictureAlignment Properties
PictureData Provider (ADO)
PicturePages PrtDevMode
PictureSizeMode PrtDevNames
PictureTiling PrtMip

Q–R

QueryTimeout (DAO) ReplicationConflictFunction
RecordCount (ADO) Report
RecordCount (DAO) Required (DAO)
RecordLocks Required
RecordsAffected (DAO) Restartable (DAO)
RecordSelectors ReturnsRecords (DAO)
RecordsetClone ReturnsRecords
RecordsetType RowHeight
RecordSource RowSource
RepeatSection RowSourceType
Replicable (DAO) RunningSum
ReplicaFilter (DAO) RunPermissions
ReplicaID (DAO)  

S

ScaleHeight Source
ScaleLeft SourceConnectStr
ScaleMode SourceDatabase
ScaleTop SourceDoc
ScaleWidth SourceField (DAO)
ScrollBars SourceItem
Section SourceObject
Selected SourceTable (DAO)
SelHeight SourceTableName (DAO)
SelLeft SpecialEffect
SelLength SQL (DAO)
SelStart SQLState (ADO)
SelText StartupForm
SelTop StartupMenuBar
SelWidth StartupShortcutMenuBar
ShortcutMenu StartupShowDBWindow
ShortcutMenuBar StartupShowStatusBar
Size (DAO) State (ADO)
SizeMode Status (ADO)
Sort (ADO) StatusBarText
Sort (DAO) StayInSync (ADO)
SortOrder StillExecuting (DAO)
Source (ADO Error Object) Style
Source (ADO Recordset Object) SystemDB (DAO)
Source (DAO)  
Source (VBA)  

T–U

TabFixedHeight Type (ADO)
TabFixedWidth Type (DAO)
TabIndex Type
Table (DAO) UnderlyingValue (ADO)
TabStop Unique (DAO)
Tag Unique
Text UniqueRecords
TextAlign UniqueValues
TimerInterval Updatable (DAO)
Toolbar UpdateOptions (DAO)
Top UpdateOptions
TopValues UserControl
Transactions (DAO) UserName (DAO)
Transparent UseTransaction
TripleState  

V–Z

V1xNullBehavior (DAO) Version (DAO)
ValidateOnSet (DAO) ViewsAllowed
ValidationRule (DAO) Visible
ValidationRule Visible (Application object)
ValidationText (DAO) VisibleValue (DAO)
ValidationText WhatsThisButton (VBA)
Value (ADO) WhatsThisButton
Value (DAO) Width
Value WillContinue
Verb WindowHeight
Version (ADO) WindowWidth