CommandButton Members (Access)
This object corresponds to a command button. A command button on a form can start an action or a set of actions. For example, you could create a command button that opens another form. To make a command button do something, you write a macro or event procedure and attach it to the button's OnClick property.
Methods
Name |
Description |
|---|---|
Moves the specified object to the coordinates specified by the argument values. |
|
The Requery method updates the data underlying a specified control that's on the active form by requerying the source of data for the control. |
|
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. |
|
You can use the SizeToFit method to size a control so it fits the text or image that it contains. |
Properties
Name |
Description |
|---|---|
Specifies whether a colon follows the text in labels for new controls. Read/write Boolean. |
|
Gets or sets how the specified button's caption and picture are aligned. Read/write Byte. |
|
You can use the Application property to access the active Microsoft Access Application object and its related properties. Read-only Application object. |
|
Specifies whether labels are automatically created and attached to new controls. Read/write Boolean. |
|
You can use the AutoRepeat property to specify whether an event procedure or macro runs repeatedly while a command button on a form remains pressed in. Read/write Boolean. |
|
Gets or sets the interior color of the specified object. Read/write Long. |
|
Gets or sets the shade that is applied to the theme color in the BackColor property of the specified object. Read/write Single. |
|
You can use the BackStyle property to specify whether a control will be transparent. Read/write Byte. |
|
Gets or sets a value that represents a color in the applied color theme associated with the BackColor property of the specified object. Read/write Long. |
|
Gets or sets the tint that is applied to the theme color in the BackColor property of the specified object. Read/write Single. |
|
Gets or sets the bevel effect applied to the specified object. Read/write Long. |
|
You can use the BorderColor property to specify the color of a control's border. Read/write Long. |
|
Gets or sets the shade that is applied to the theme color in the BorderColor property of the specified object. Read/write Single. |
|
Specifies how a control's border appears.Read/write Byte. |
|
Gets or sets a value that represents a color in the applied color theme associated with the BorderColor property of the specified object. Read/write Long. |
|
Gets or sets the tint that is applied to the theme color in the BorderColor property of the specified object. Read/write Single. |
|
You can use the BorderWidth property to specify the width of a control's border. Read/write Byte. |
|
Gets or sets the amount of space (in inches) between the button and its bottom gridline. Read/write Integer. |
|
You can use the Cancel property to specify whether a command button is also the Cancel button on a form. Read/write Boolean. |
|
Gets or sets the text that appears in the control. Read/write String. |
|
Returns the Controls collection of a form, subform, report or section. Read-only Controls. |
|
You can use the ControlTipText property to specify the text that appears in a ScreenTip when you hold the mouse pointer over a control. Read/write String. |
|
You can use the ControlType property in Visual Basic to determine the type of a control on a form or report. Read/write Byte. |
|
Gets or sets the type of mouse cursor displayed when the user rests the pointer on a button. Read/write AcCursorOnHover. |
|
You can use the Default property to specify whether a command button is the default button on a form. Read/write Boolean. |
|
You can use the DisplayWhen property to specify which of a form's controls you want displayed on screen and in print. Read/write Byte. |
|
You can use the Enabled property to set or return the status of the conditional format in the FormatCondition object. Read/write Boolean. |
|
Gets or sets the prefix portion of an event procedure name. Read/write String. |
|
You can use the FontBold property to specify whether a font appears in a bold style in the following situations:
Read/write Boolean. |
|
You can use the FontItalic property to specify whether text is italic in the following situations:
Read/write Boolean. |
|
You can use the FontName property to specify the font for text in the following situations:
Read/write String. |
|
You can use the FontSize property to specify the point size for text in the following situations:
Read/write Integer. |
|
You can use the FontUnderline property to specify whether text is underlined in the following situations:
Read/write Boolean. |
|
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. |
|
You can use the ForeColor property to specify the color for text in a control. Read/write Long. |
|
Gets or sets the shade that is applied to the theme color in the ForeColor property of the specified object. Read/write Single. |
|
Gets or sets a value that represents a color in the applied color theme associated with the ForeColor property of the specified object. Read/write Long. |
|
Gets or sets the tint that is applied to the theme color in the ForeColor property of the specified object. Read/write Single. |
|
Gets or sets the Glow effect applied to the specified object. Read/write Long. |
|
Gets or sets the gradient fill applied to the specified object. Read/write Long. |
|
Gets or sets the color of the gridline for the specified command button. Read/write Long. |
|
Gets or sets the shade applied to the theme color in the GridlineColor property of the specified object. Read/write Single. |
|
Gets or sets the bottom gridline style of the specified button. Read/write Byte. |
|
Gets or sets the width of the bottom gridline for the specified button. Read/write Byte. |
|
Gets or sets the right gridline style of the specified button. Read/write Byte. |
|
Gets or sets the top gridline style of the specified button. Read/write Byte. |
|
Gets or sets the theme color index that represents a color in the applied color theme associated with the GridlineColor property of the specified object. Read/write Long. |
|
Gets or sets the tint applied to the theme color in the GridlineColor property of the specified object. Read/write Single. |
|
Gets or sets the width of the bottom gridline for the specified button. Read/write Byte. |
|
Gets or sets the width of the left gridline for the specified button. Read/write Byte. |
|
Gets or sets the width of the right gridline for the specified button. Read/write Byte. |
|
Gets or sets the width of the top gridline for the specified button. Read/write Byte. |
|
Gets or sets the height of the specified object in twips. Read/write Integer. |
|
The HelpContextID property specifies the context ID of a topic in the custom Help file specified by the HelpFile property setting. Read/write Long. |
|
Gets or sets an AcHorizontalAnchor constant that indicates how the button is anchored horizontally within its layout. Read/write. |
|
Gets or sets the color displayed on the control when the user rests the mouse cursor over it. Read/write Long. |
|
Gets or sets the color of the text displayed on the control when the user rests the mouse cursor over it. Read/write Long. |
|
Gets or sets the shade applied to the theme color in the HoverForeColor property of the specified object. Read/write Single. |
|
Gets or sets the theme color index that represents a color in the applied color theme associated with the HoverForeColor property of the specified object. Read/write Long. |
|
Gets or sets the tint applied to the theme color in the HoverForeColor property of the specified object. Read/write Single. |
|
Gets or sets the shade that is applied to the theme color in the HoverColor property of the specified object. Read/write Single. |
|
Gets or sets the theme color index that represents a color in the applied color theme associated with the HoverColor property of the specified object. Read/write Long. |
|
Gets or sets the tint applied to the theme color in the HoverColor property of the specified object. Read/write Single. |
|
You can use the Hyperlink property to return a reference to a Hyperlink object. You can use the Hyperlink property to access the properties and methods of a control's hyperlink. Read-only. |
|
You can use the HyperlinkAddress property to specify or determine the path to an object, document, Web page or other destination for a hyperlink associated with a the specified control. Read/write String. |
|
You can use the HyperlinkSubAddress property to specify or determine a location within the target document specified by the HyperlinkAddress property. Read/write String. |
|
You can use the InSelection property to determine or specify whether a control on a form in Design view is selected. Read/write Boolean. |
|
You can use the IsVisible property in to determine whether a control on a report is visible. Read/write Boolean. |
|
The property specifies the text alignment within attached labels on new controls. Read/write Byte. |
|
|
The LabelX property (along with the LabelY property) specifies the placement of the label for a new control. Read/write Integer. |
|
|
The LabelY property (along with the LabelX property) specifies the placement of the label for a new control. Read/write Integer. |
|
Returns the type of layout for the specified button. Read-only AcLayoutType. |
|
Returns the unique identifier for the layout that contains the specified button. Read-only Long. |
|
You can use the Left property to specify an object's location on a form or report. Read/write Integer. |
|
Gets or sets the amount of space (in inches) between the button and its left gridline. Read/write Integer. |
|
You can use the Name property to specify or determine the string expression that identifies the name of an object. Read/write String. |
|
The ObjectPalette property specifies the palette in the application used to create A bitmap or other graphic that is loaded into the specified control by using the Picture property. Read/write Variant. |
|
You can use the OldValue property to determine the unedited value of a bound control. Read-only Variant. |
|
Sets or returns the value of the On Click box in the Properties window. Read/write String. |
|
Sets or returns the value of the On Dbl Click box in the Properties window. Read/write String. |
|
Sets or returns the value of the On Enter box in the Properties window of specified object. Read/write String. . |
|
Sets or returns the value of the On Exit box in the Properties window of specified object. Read/write String. . |
|
Sets or returns the value of the On Got Focus box in the Properties window of the specified object. Read/write String. |
|
Sets or returns the value of the On Key Down box in the Properties window. Read/write String. |
|
Sets or returns the value of the On Key Press box in the Properties window. Read/write String. |
|
Sets or returns the value of the On Key Up box in the Properties window. Read/write String. |
|
Sets or returns the value of the On Lost Focus box in the Properties window of the specified object. Read/write String. |
|
Sets or returns the value of the On Mouse Down box in the Properties window. Read/write String. |
|
Sets or returns the value of the On Mouse Move box in the Properties window. Read/write String. |
|
Sets or returns the value of the On Mouse Up box in the Properties window. Read/write String. |
|
Sets or returns the value of the On Click box in the Properties window of a command button. Read/write String. |
|
Returns the parent object for the specified object. Read-only. |
|
You can use the Picture property to specify a bitmap or other type of graphic to be displayed on the specified control. Read/write String. |
|
Gets or sets how the specified button's caption is arranged in relation to its picture. Read/write AcPictureCaptionArrangement. |
|
You can use the PictureData property to copy the picture to another object that supports the Picture property. Read/write Variant. |
|
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. |
|
Gets or sets the color displayed on the control when the user clicks it. Read/write Long. |
|
Gets or sets the color of the text displayed on the control when the user clicks it. Read/write Long. |
|
Gets or sets the shade applied to the theme color in the PressedForeColor property of the specified object. Read/write Single. |
|
Gets or sets the theme color index that represents a color in the applied color theme associated with the PressedForeColor property of the specified object. Read/write Long. |
|
Gets or sets the tint applied to the theme color in the PressedForeColor property of the specified object. Read/write Single. |
|
Gets or sets the shade that is applied to the theme color in the PressedColor property of the specified object. Read/write Single. |
|
Gets or sets the theme color index that represents a color in the applied color theme associated with the PressedColor property of the specified object. Read/write Long. |
|
Gets or sets the tint applied to the theme color in the PressedColor property of the specified object. Read/write Single. |
|
Returns a reference to a control's Properties collection object. Read-only. |
|
Gets or sets the Quick Style that is applied to the specified object. Read/write Long. |
|
You can use the ReadingOrder property to specify or determine the reading order of words in text. Read/write Byte. |
|
Gets or sets the amount of space (in inches) between the button and its right gridline. Read/write Integer. |
|
You can identify these controls by the section of a form or report where the control appears. Read/write Integer. |
|
Gets or sets the Shadow effect applied to the specified object. Read/write Long. |
|
Returns or sets the shape of the specified button. Read/write Long. |
|
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. |
|
Gets or sets the Soft Edges effect applied to the specified object. Read/write Long. |
|
You can use the StatusBarText property to specify the text that is displayed in the status bar when a control is selected. Read/write String. |
|
You can use the TabIndex property to specify a control's place in the tab order on a form or report. Read/write Integer. |
|
You can use the TabStop property to specify whether you can use the TAB key to move the focus to a control. Read/write Boolean. |
|
Stores extra information about a form, report, section, or control needed by a Microsoft Access application. Read/write String. |
|
Gets or sets the font index that represents a font in the applied theme associated with the FontName property of the specified object. Read/write Long. |
|
You can use the Top property to specify an object's location on a form or report. Read/write Integer. . |
|
Gets or sets the amount of space (in inches) between the button and its top gridline. Read/write Integer. |
|
You can use the Transparent property to specify whether a command button is solid or transparent. Read/write Boolean. |
|
Gets or sets whether the specified object will utilize formatting styles defined in Office Document Themes. Read/write Boolean. |
|
Gets or sets an AcVerticalAnchor constant that indicates how the specified button is anchored vertically within its layout. Read/write. |
|
Returns or sets whether the object is visible. Read/write Boolean. |
|
Gets or sets the width of the specified object in twips. Read/write Integer. |
.gif "Note")
Note
Events
Name |
Description |
|---|---|
The Click event occurs when the user presses and then releases a mouse button over an object. |
|
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. |
|
The Enter event occurs before a control actually receives the focus from a control on the same form or report. |
|
The Exit event occurs just before a control loses the focus to another control on the same form or report. |
|
The GotFocus event occurs when the specified object receives the focus. |
|
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. |
|
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. |
|
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. |
|
The LostFocus event occurs when the specified object loses the focus. |
|
The MouseDown event occurs when the user presses a mouse button. |
|
The MouseMove event occurs when the user moves the mouse. |
|
The MouseUp event occurs when the user releases a mouse button. |