Form Object Members

Article
06/14/2014

Access Developer Reference

A Form object refers to a particular Microsoft Access form.

Methods

	Name	Description
	GoToPage	The GoToPage method moves the focus to the first control on a specified page in the active form.
	Move	Moves the specified object to the coordinates specified by the argument values.
	Recalc	The Recalc method immediately updates all calculated controls on a form.
	Refresh	The Refresh method immediately updates the records in the underlying record source for a specified form or datasheet to reflect changes made to the data by you and other users in a multiuser environment.
	Repaint	The Repaint method completes any pending screen updates for a specified form. When performed on a form, the Repaint method also completes any pending recalculations of the form's controls.
	Requery	The Requery method updates the data underlying a specified form by requerying the source of data for the form.
	SetFocus	The SetFocus method moves the focus to the specified form, the specified control on the active form, or the specified field on the active datasheet.
	Undo	You can use the Undo method to reset a control or form when its value has been changed.

Properties

	Name	Description
	ActiveControl	You can use the ActiveControl property together with the Screen object to identify or refer to the control that has the focus. Read-only Control object.
	AfterDelConfirm	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the AfterDelConfirm event occurs. Read/write.
	AfterFinalRender	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the AfterFinalRender event occurs. Read/write.
	AfterInsert	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the AfterInsert event occurs. Read/write.
	AfterLayout	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the AfterLayout event occurs. Read/write.
	AfterRender	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the AfterFinalRender event occurs. Read/write.
	AfterUpdate	Returns or sets which macro, event procedure, or user-defined function runs when the AfterUpdate event occurs. Read/write String.
	AllowAdditions	You can use the AllowAdditions property to specify whether a user can add a record when using a form. Read/write Boolean.
	AllowDatasheetView	Returns or sets a Boolean indicating whether the specified form may be viewed in Datasheet View. True if Datasheet View is allowed. Read/write.
	AllowDeletions	You can use the AllowDeletions property to specify whether a user can delete a record when using a form. Read/write Boolean.
	AllowEdits	You can use the AllowEdits property to specify whether a user can edit saved records when using a form. Read/write Boolean.
	AllowFilters	You can use the AllowFilters property to specify whether records in a form can be filtered. Read/write Boolean.
	AllowFormView	Returns or sets a Boolean indicating whether the specified form may be viewed in Form View. True if Form View is allowed. Read/write.
	AllowLayoutView	Gets or sets whether the specified form can be used in Layout View. Read/write Boolean.
	AllowPivotChartView	Returns or sets a Boolean indicating whether the specified form may be viewed in PivotChart View. True if PivotChart View is allowed. Read/write.
	AllowPivotTableView	Returns or sets a Boolean indicating whether the specified form may be viewed in PivotTable View. True if PivotTable View is allowed. Read/write.
	Application	You can use the Application property to access the active Microsoft Access Application object and its related properties. Read-only Application object.
	AutoCenter	Returns or sets a Boolean indicating whether a form will be centered automatically in the application window when the form is opened. Read/write.
	AutoResize	Returns or sets a Boolean indicating whether a Form window opens automatically sized to display complete records. Read/write.
	BeforeDelConfirm	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the BeforeDelConfirm event occurs. Read/write.
	BeforeInsert	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the BeforeInsert event occurs. Read/write.
	BeforeQuery	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the BeforeQuery event occurs. Read/write.
	BeforeRender	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the BeforeRender event occurs. Read/write.
	BeforeScreenTip	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the BeforeScreenTip event occurs. Read/write.
	BeforeUpdate	Returns or sets which macro, event procedure, or user-defined function runs when the BeforeUpdate event occurs. Read/write String.
	Bookmark	You can use the Bookmark property with forms to set a bookmark that uniquely identifies a particular record in the form's underlying table, query, or SQL statement. Read/write Variant.
	BorderStyle	Specifies the type of border and border elements (title bar, Control menu, Minimize and Maximize buttons, or Close button) to use for the form. You typically use different border styles for normal forms, pop-up forms, and custom dialog boxes. Read/write Byte.
	Caption	Gets or sets the text that appears in the title bar in Form view. Read/write String.
	ChartSpace	Returns a ChartSpace object. Read-only.
	CloseButton	Specifies whether the Close button on a form is enabled. Read/write Boolean.
	CommandBeforeExecute	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the CommandBeforeExecute event occurs. Read/write.
	CommandChecked	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the CommandChecked event occurs. Read/write.
	CommandEnabled	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the CommandEnabled event occurs. Read/write.
	CommandExecute	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the CommandExecute event occurs. Read/write.
	ControlBox	Specifies whether a form has a Control menu in Form view and Datasheet view. Read/write Boolean.
	Controls	Returns the Controls collection of a form, subform, report or section. Read-only Controls.
	Count	You can use the Count property to determine the number of items in a specified collection. Read-only Integer
	CurrentRecord	You can use the CurrentRecord property to identify the current record in the recordset being viewed on a form. Read/write Long.
	CurrentSectionLeft	You can use this property to determine the distance in twips from the left side of the current section to the left side of the form. Read/write Integer.
	CurrentSectionTop	You can use this property to determine the distance in twips from the top edge of the current section to the top edge of the form. Read/write Integer.
	CurrentView	You can use the CurrentView property to determine how a form 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 bound form. Read/write Byte.
	DataChange	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the DataChange event occurs. Read/write.
	DataEntry	You can use the DataEntry property to specify whether a bound form opens to allow data entry only. The Data Entry property doesn't determine whether records can be added; it only determines whether existing records are displayed. Read/write Boolean.
	DataSetChange	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the DataSetChange event occurs. Read/write.
	DatasheetAlternateBackColor	Gets or sets the color displayed on alternate rows of a form's datasheet. Read/write Long.
	DatasheetBackColor	You can use the DatasheetBackColor property in Visual Basic to specify or determine the background color of an entire table, query, or form in Datasheet view within a Microsoft Access database. Read/write Long.
	DatasheetBorderLineStyle	Returns or sets a Byte indicating the line style to use for the border of the specified datasheet. Read/write.
	DatasheetCellsEffect	You can use the DatasheetCellsEffect property to specify whether special effects are applied to cells in a datasheet. Read/write Byte.
	DatasheetColumnHeaderUnderlineStyle	Returns or sets a Byte indicating the line style to use for the bottom edge of the column headers on the specified datasheet. Read/write.
	DatasheetFontHeight	You can use the DatasheetFontHeight property to specify the font point size used to display and print field names and data in Datasheet view. Read/write Integer.
	DatasheetFontItalic	You can use the DatasheetFontItalic property to specify an italicized appearance for field names and data in Datasheet view. Read/write Boolean.
	DatasheetFontName	You can use the DatasheetFontName property to specify the font used to display and print field names and data in Datasheet view. Read/write String.
	DatasheetFontUnderline	You can use the DatasheetFontUnderline property to specify an underlined appearance for field names and data in Datasheet view. Read/write Boolean.
	DatasheetFontWeight	You can use the DatasheetFontWeight property to specify the line width of the font used to display and print characters for field names and data in Datasheet view. Read/write Integer.
	DatasheetForeColor	You can use the DatasheetForeColor property in Visual Basic to specify or determine the color of all text in a table, query, or form in Datasheet view within an Access database. Read/write Long.
	DatasheetGridlinesBehavior	You can use the DatasheetGridlinesBehavior property to specify which gridlines will appear in Datasheet view. Read/write Byte.
	DatasheetGridlinesColor	You can use the DatasheetGridlinesColor property to specify the color of gridlines in a datasheet. Read/write Long.
	DefaultControl	The DefaultControl property returns a Control object with which you can set the default properties for a particular type of control on a particular form. Read-only.
	DefaultView	You can use the DefaultView property to specify the opening view of a form. Read/write Byte.
	Dirty	You can use the Dirty property to determine whether the current record has been modified since it was last saved. Read/write Boolean.
	DisplayOnSharePointSite	Gets or sets whether the specified form can be made available as a view on a 1st_WSS_3 site. Read/write Byte.
	DividingLines	You can use the DividingLines property to specify whether dividing lines will separate sections on a form or records displayed on a continuous form. Read/write Boolean.
	FastLaserPrinting	You can use the FastLaserPrinting property to specify whether lines and rectangles are replaced by text character lines — similar to the underscore (_) and vertical bar (\|) characters — when you print a form using most laser printers. Replacing lines and rectangles with text character lines can make printing much faster. Read/write Boolean.
	FetchDefaults	Returns or sets a Boolean indicating whether Microsoft Access shows default values for new rows on the specified form before the row is saved. True if Access shows the default values for new rows on the specified form. Read/write.
	Filter	You can use the Filter property to specify a subset of records to be displayed when a filter is applied to a form, report query, or table. Read/write String.
	FilterOn	You can use the FilterOn property to specify or determine whether the Filter property for a form or report is applied. Read/write Boolean.
	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.
	Form	You can use the Form property to refer to a form or to refer to the form associated with a subform control. Read-only Form.
	FrozenColumns	You can use the FrozenColumns property to determine how many columns in a datasheet are frozen. Read/write Integer
	GridX	You can use the GridX property (along with the GridY property) to specify the horizontal and vertical divisions of the alignment grid in form Design view. Read/write Integer.
	GridY	You can use the GridY property (along with the GridX property) to specify the horizontal and vertical divisions of the alignment grid in form Design view. Read/write Integer.
	HasModule	You can use the HasModule property to specify or determine whether a form or report has a class module. Read/write Boolean.
	HelpContextId	The HelpContextID property specifies the context ID of a topic in the custom Help file specified by the HelpFile property setting. Read/write Long.
	HelpFile	The name of a help file associated with a form. Read/write String.
	HorizontalDatasheetGridlineStyle	Returns or sets a Byte indicating the line style to use for horizontal gridlines on the specified datasheet. Read/write.
	Hwnd	You can use the hWnd property to determine the handle (a unique Long Integer value) assigned by Microsoft Windows to the current window. Read/write Long.
	InputParameters	You can use the InputParameters property to specify or determine the input parameters that are passed to a SQL statement in the RecordSource property of a form or report or a stored procedure when used as the record source within a Microsoft Access project (.adp). Read/write String.
	InsideHeight	You can use the InsideHeight property (along with the InsideWidth property) to determine the height and width (in twips) of the window containing a form. Read/write Long.
	InsideWidth	You can use the InsideWidth property (along with the InsideHeight property) to determine the height and width (in twips) of the window containing a form. Read/write Long.
	KeyPreview	You can use the KeyPreview property to specify whether the form-level keyboard event procedures are invoked before a control's keyboard event procedures. Read/write Boolean.
	LayoutForPrint	You can use the LayoutForPrint property to specify whether the form uses printer or screen fonts. Read/write Boolean.
	MaxRecButton	You can use the MaxRecButton property to specify or determine if the maximum record limit button is available on the navigation bar of a form in Datasheet view or Form view. Read/write Boolean.
	MaxRecords	Specifies the maximum number of records by a query or view. Read/write Long.
	MenuBar	Specifies a custom menu to display for a form. Read/write String.
	MinMaxButtons	You can use the MinMaxButtons property to specify whether the Maximize and Minimize buttons will be visible on a form. Read/write Byte.
	Modal	You can use the Modal property to specify whether a form opens as a modal window. When a form opens as a modal window, you must close the window before you can move the focus to another object. Read/write Boolean.
	Module	You can use the Module property to specify a form module. Read-only Module object.
	MouseWheel	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the MouseWheel event occurs. Read/write.
	Moveable	Returns or sets a Boolean indicating whether the specified form can be moved by the user; True if it can be moved. Read/write.
	Name	You can use the Name property to specify or determine the string expression that identifies the name of an object. Read/write String.
	NavigationButtons	You can use the NavigationButtons property to specify whether navigation buttons and a record number box are displayed on a form. Read/write Boolean.
	NavigationCaption	Gets or sets the text that appears to the left of the form's navigation buttons. Read/write String.
	NewRecord	You can use the NewRecord property to determine whether the current record is a new record. Read-only Integer.
	OnActivate	Sets or returns the value of the On Activate box in the Properties window of a form or report. Read/write String.
	OnApplyFilter	Sets or returns the value of the On Apply Filter box in the Properties window of a form. Read/write String.
	OnClick	Sets or returns the value of the On Click box in the Properties window. Read/write String.
	OnClose	Sets or returns the value of the On Close box in the Properties window of a form or report. Read/write String.
	OnConnect	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the OnConnect event occurs. Read/write.
	OnCurrent	Sets or returns the value of the On Current box in the Properties window of a form. Read/write String.
	OnDblClick	Sets or returns the value of the On Dbl Click box in the Properties window. Read/write String.
	OnDeactivate	Sets or returns the value of the On Deactivate box in the Properties window of a form or report. Read/write String.
	OnDelete	Sets or returns the value of the On Delete box in the Properties window of a form. Read/write String.
	OnDirty	Sets or returns the value of the On Dirty box in the Properties window of a form or report. Read/write String.
	OnDisconnect	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the OnDisconnect event occurs. Read/write.
	OnError	Sets or returns the value of the OnError box in the Properties window of a form or report. Read/write String.
	OnFilter	Sets or returns the value of the On Filter box in the Properties window of a form. Read/write String.
	OnGotFocus	Sets or returns the value of the On Got Focus box in the Properties window of the specified object. Read/write String.
	OnInsert	Sets or returns the value of the Before Insert box in the Properties window of a form. 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 form. Read/write String.
	OnLostFocus	Sets or returns the value of the On Lost Focus box in the Properties window of the specified object. Read/write String.
	OnMenu	Sets or returns the value of the On Menu box in the Properties window of a form or 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.
	OnOpen	Sets or returns the value of the On Open box in the Properties window of a form or report. 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.
	OnUndo	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the Undo event occurs. Read/write..
	OnUnload	Sets or returns the value of the On Unload box in the Properties window of a form. Read/write String.
	OpenArgs	Determines the string expression specified by the OpenArgs argument of the OpenForm method that opened a form. Read/write Variant.
	OrderBy	You can use the OrderBy property to specify how you want to sort records in a form. Read/write String.
	OrderByOn	You can use the OrderByOn property to specify whether an object's OrderBy property setting is applied. Read/write Boolean.
	OrderByOnLoad	Gets or sets whether the sorting specified by the OrderBy property is applied when the report is loaded. Read/write Boolean.
	Orientation	You can use the Orientation property to specify or determine the view orientation. Read/write Byte.
	Page	The Page property specifies the current page number when a form is being printed. Read/write Long.
	Pages	You can use the Pages property to return information needed to print page numbers in a form. Read/write Integer.
	Painting	You can use the Painting property to specify whether a form is repainted. Read/write Boolean.
	PaintPalette	You can use the PaintPalette property to specify a palette to be used by a form. Read/write Variant.
	PaletteSource	You can use the PaletteSource property to specify the palette for a form. Read/write String.
	Parent	Returns the parent object for the specified object. Read-only.
	Picture	You can use the Picture property to specify a bitmap or other type of graphic to be used as a background picture on a form. Read/write String.
	PictureAlignment	You can use the PictureAlignment property to specify where a background picture will appear in an image control or on a form or report. Read/write Byte.Read/write
	PictureData	You can use the PictureData property to copy the picture to another object that supports the Picture property. Read/write Variant.
	PicturePalette	You can use the PicturePalette property to specify a palette to be used by a form. Read/write Variant.
	PictureSizeMode	You can use the PictureSizeMode property to specify how a picture for a form or report is sized. Read/write Byte.
	PictureTiling	You can use the PictureTiling property to specify whether a background picture is tiled across the entire image control, Form window, form, or page of a report. Read/write Boolean.
	PictureType	You can use the PictureType property to specify whether Microsoft Access stores an object's picture as a linked or an embedded object. Read/write Byte.
	PivotTable	Returns a PivotTable object representing a PivotTable View on a form. Read-only.
	PivotTableChange	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the PivotTableChange event occurs. Read/write.
	PopUp	Specifies whether a form opens as a pop-up window. Read/write Boolean.
	Printer	Returns or sets a Printer object representing the default printer on the current system. Read/write.
	Properties	Returns a reference to a control's Properties collection object. Read-only.
	PrtDevMode	You can use the PrtDevMode property to set or return printing device mode information specified for a form or report in the Print dialog box. Read/write Variant.
	PrtDevNames	You can use the PrtDevNames property to set or return information about the printer selected in the Print dialog box for a form or report. Read/write Variant.
	PrtMip	Read/write
	Query	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the Query event occurs. Read/write.
	RecordLocks	You can use the RecordLocks property to determine how records are locked and what happens when two users try to edit the same record at the same time. Read/write.
	RecordSelectors	You can use the RecordSelectors property to specify whether a form displays record selectors in Form view. Read/write Boolean.
	Recordset	Returns or sets the ADO Recordset or DAO Recordset object representing the record source for the specified object. Read/write Object.
	RecordsetClone	You can use the RecordsetClone property to refer to a form's Recordset object specified by the form's RecordSource property. Read-only.
	RecordsetType	You can use the RecordsetType property to specify what kind of recordset is made available to a form. Read/write Byte.
	RecordSource	You can use the RecordSource property to specify the source of the data for a form. Read/write String.
	RecordSourceQualifier	Returns or sets a String indicating the SQL Server owner name of the record source for the specified form. Read/write.
	ResyncCommand	You can use the ResyncCommand property to specify or determine the SQL statement or stored procedure that will be used in an updateable snapshot of a table. Read/write String.
	RibbonName	Gets or set the name of the customized Ribbon to be displayed when the specified form is loaded. Read/write String.
	RowHeight	You can use the RowHeight property to specify the height of all rows in Datasheet view. Read/write Integer.
	ScrollBars	You can use the ScrollBars property to specify whether scroll bars appear on a form. Read/write Byte.
	Section	You can use the Section property to identify a section of a form and provide access to the properties of that section. Read-only Section object.
	SelectionChange	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the SelectionChange event occurs. Read/write.
	SelHeight	You can use the SelHeight property to specify or determine the number of selected rows (records) in the current selection rectangle in a table, query, or form datasheet, or the number of selected records in a continuous form. Read/write Long.
	SelLeft	You can use the SelLeft property to specify or determine which column (field) is leftmost in the current selection rectangle. Read/write Long.
	SelTop	You can use the SelTop property to specify or determine which row (record) is topmost in the current selection rectangle in a table, query, or form datasheet, or which selected record is topmost in a continuous form.Read/write Long.
	SelWidth	You can use the SelWidth property to specify or determine the number of selected columns (fields) in the current selection rectangle. Read/write Long.
	ServerFilter	You can use the ServerFilter property to specify a subset of records to be displayed when a server filter is applied to a form within a Microsoft Access project (.adp) or database. Read/write String.
	ServerFilterByForm	You can use the ServerFilterByForm property to specify or determine whether a form is opened in the Server Filter By Form window. Read/write Boolean.
	ShortcutMenu	You can use the ShortcutMenu property to specify whether a shortcut menu is displayed when you right-click an object on a form. For example, you might want to disable a shortcut menu to prevent the user from changing the form's underlying record source by using one of the filtering commands on the form's shortcut menu. Read/write Boolean.
	ShortcutMenuBar	You can use the ShortcutMenuBar property to specify the shortcut menu that will appear when you right-click on the specified object. 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.
	SubdatasheetExpanded	You can use the SubdatasheetExpanded property to specify or determine the saved state of all subdatasheets within a table or query. Read/write Boolean.
	SubdatasheetHeight	You can use the SubdatasheetHeight property to specify or determine the default display height of a subdatasheet when expanded. Read/write Integer.
	Tag	Stores extra information about a form, report, section, or control needed by a Microsoft Access application. Read/write String.
	TimerInterval	You can use the TimerInterval property to specify the interval, in milliseconds, between Timer events on a form. Read/write Long.
	Toolbar	Specifies a custom toolbar to display for a form. Read/write String.
	UniqueTable	Specifies the table to be updateable when A form is bound to a multiple table view or stored procedure within a Microsoft Access project (.adp).
	UseDefaultPrinter	Returns or sets a Boolean indicating whether the specified form uses the default printer for the system; True if the form or report uses the default printer. Read/write.
	VerticalDatasheetGridlineStyle	Returns or sets a Byte indicating the line style to use for vertical gridlines on the specified datasheet. Read/write.
	ViewChange	Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the ViewChange event occurs. Read/write.
	ViewsAllowed	You can use the ViewsAllowed property to specify whether users can switch between Datasheet view and Form view by clicking the Form View or Datasheet View command on the View menu or by clicking the arrow next to the View button and clicking Form View or Datasheet View. Read/write Byte.
	Visible	Returns or sets whether the object is visible. Read/write Boolean.
	Width	Gets or sets the width of the specified object in twips. Read/write Integer.
	WindowHeight	Returns the height of a form in twips. Read-only Integer.
	WindowLeft	Returns an Integer indicating the screen position in twips of the left edge of a form relative to the left edge of the Microsoft Access window. Read-only.
	WindowTop	Returns an Integer indicating the screen position in twips of the top edge of a form relative to the top of the Microsoft Access window. Read-only.
	WindowWidth	Returns the height of a form in twips. Read-only Integer.

Events

	Name	Description
	Activate	The Activate event occurs when a form receives the focus and becomes the active window.
	AfterDelConfirm	The AfterDelConfirm event occurs after the user confirms the deletions and the records are actually deleted or when the deletions are canceled.
	AfterFinalRender	Occurs after all elements in the specified PivotChart view have been rendered.
	AfterInsert	The AfterInsert event occurs after a new record is added.
	AfterLayout	Occurs after all charts in the specfied PivotChart view have been laid out, but before they have been rendered.
	AfterRender	Occurs after the object represented by the chartObject argument has been rendered.
	AfterUpdate	The AfterUpdate event occurs after changed data in a control or record is updated.
	ApplyFilter	Occurs when a filter is applied to a form.
	BeforeDelConfirm	The BeforeDelConfirm event occurs after the user deletes to the buffer one or more records, but before Microsoft Access displays a dialog box asking the user to confirm the deletions.
	BeforeInsert	The BeforeInsert event occurs when the user types the first character in a new record, but before the record is actually created.
	BeforeQuery	Occurs when the specified PivotTable view queries its data source.
	BeforeRender	Occurs before any object in the specified PivotChart view has been rendered.
	BeforeScreenTip	Occurs before a ScreenTip is displayed for an element in a PivotChart view or PivotTable view.
	BeforeUpdate	The BeforeUpdate event occurs before changed data in a control or record is updated.
	Click	The Click event occurs when the user presses and then releases a mouse button over an object.
	Close	The Close event occurs when a form is closed and removed from the screen.
	CommandBeforeExecute	Occurs before a specified command is executed. Use this event when you want to impose certain restrictions before a particular command is executed.
	CommandChecked	Occurs when the specified Microsoft Office Web Component determines whether the specified command is checked.
	CommandEnabled	Occurs when the specified Microsoft Office Web Component determines whether the specified command is enabled.
	CommandExecute	Occurs after the specified command is executed. Use this event when you want to execute a set of commands after a particular command is executed.
	Current	Occurs when the focus moves to a record, making it the current record, or when the form is refreshed or requeried.
	DataChange	Occurs when certain properties are changed or when certain methods are executed in the specified PivotTable view.
	DataSetChange	Occurs whenever the specified PivotTable view is data-bound and the data set changes — for example, when a filter operation takes place. This event also occurs when initial data is available from the data source.
	DblClick	The DblClick event occurs when the user presses and releases the left mouse button twice over an object within the double-click time limit of the system.
	Deactivate	The Deactivate event occurs when a form loses the focus to a Table, Query, Form, Report, Macro, or Module window, or to the Database window.
	Delete	Occurs when the user performs some action, such as pressing the DEL key, to delete a record, but before the record is actually deleted.
	Dirty	The Dirty event occurs when the contents of the specified control changes.
	Error	The Error event occurs when a run-time error is produced in Microsoft Access when a form has the focus.
	Filter	Occurs when the user opens a filter window by clicking Filter by Form, Advanced Filter/Sort, or Server Filter By Form.
	GotFocus	The GotFocus event occurs when the specified object receives the focus.
	KeyDown	The KeyDown event occurs when the user presses a key while a form or control has the focus. This event also occurs if you send a keystroke to a form or control 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 form or control has the focus. This event also occurs if you send an ANSI keystroke to a form or control 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 form or control has the focus. This event also occurs if you send a keystroke to a form or control by using the SendKeys action in a macro or the SendKeys statement in Visual Basic.
	Load	Occurs when a form 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.
	MouseMove	The MouseMove event occurs when the user moves the mouse.
	MouseUp	The MouseUp event occurs when the user releases a mouse button.
	MouseWheel	Occurs when the user rolls the mouse wheel in Form View, Split Form View, Datasheet View, Layout View, PivotChart View, or PivotTable View.
	OnConnect	Occurs when the specified PivotTable view connects to a data source.
	OnDisconnect	Occurs when the specified PivotTable view disconnects from a data source.
	Open	The Open event occurs when a form is opened, but before the first record is displayed.
	PivotTableChange	Occurs whenever the specified PivotTable view field, field set, or total is added or deleted.
	Query	Occurs whenever the specified PivotTable view query becomes necessary. The query may not occur immediately; it may be delayed until the new data is displayed.
	Resize	The Resize event occurs when a form is opened and whenever the size of a form changes.
	SelectionChange	Occurs whenever the user makes a new selection in a PivotChart view or PivotTable view.
	Timer	The Timer event occurs for a form at regular intervals as specified by the form's TimerInterval property.
	Undo	Occurs when the user undoes a change.
	Unload	The Unload event occurs after a form is closed but before it's removed from the screen. When the form is reloaded, Microsoft Access redisplays the form and reinitializes the contents of all its controls.
	ViewChange	Occurs whenever the specified PivotChart view or PivotTable view is redrawn.

Share via

Form Object Members

Additional resources