Export (0) Print
Expand All

SubForm Members (Access)

This object corresponds to a subform control. The subform control embeds a form in a form.

Name

Description

Move

Moves the specified object to the coordinates specified by the argument values.

Requery

The Requery method updates the data underlying a specified subform by requerying the source of data for the subform.

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.

SizeToFit

You can use the SizeToFit method to size a control so it fits the text or image that it contains.

Name

Description

AddColon

Specifies whether a colon follows the text in labels for new controls. Read/write Boolean.

Application

You can use the Application property to access the active Microsoft Access Application object and its related properties. Read-only Application object.

AutoLabel

Specifies whether labels are automatically created and attached to new controls. Read/write Boolean.

BorderColor

You can use the BorderColor property to specify the color of a control's border. Read/write Long.

BorderShade

Gets or sets the shade that is applied to the theme color in the BorderColor property of the specified object. Read/write Single.

BorderStyle

Specifies how a control's border appears.Read/write Byte.

BorderThemeColorIndex

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.

BorderTint

Gets or sets the tint that is applied to the theme color in the BorderColor property of the specified object. Read/write Single.

BorderWidth

You can use the BorderWidth property to specify the width of a control's border. Read/write Byte.

BottomPadding

Gets or sets the amount of space (in inches) between the subform 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 section or control contains. Read/write Boolean.

Controls

Returns the Controls collection of a form, subform, report or section. Read-only Controls.

ControlType

You can use the ControlType property in Visual Basic to determine the type of a control on a form or report. Read/write Byte.

DisplayWhen

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.

Enabled

You can use the Enabled property to set or return the status of the conditional format in the FormatCondition object. Read/write Boolean.

EventProcPrefix

Gets or sets the prefix portion of an event procedure name. Read/write String.

FilterOnEmptyMaster

Gets or sets whether all records are displayed when the subform's master field is Null. Read/write Boolean.

Form

You can use the Form property to refer to a form or to refer to the form associated with a subformcontrol. Read-only Form.

GridlineColor

Gets or sets the color of the gridline for the specified subform. Read/write Long.

GridlineShade

Gets or sets the shade applied to the theme color in the GridlineColor property of the specified object. Read/write Single.

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.

GridlineThemeColorIndex

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.

GridlineTint

Gets or sets the tint applied to the theme color in the GridlineColor property of the specified object. Read/write Single.

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.

Height

Gets or sets the height of the specified object in twips. Read/write Integer.

HorizontalAnchor

Gets or sets an AcHorizontalAnchor constant that indicates how the subform is anchored horizontally within its layout. Read/write.

InSelection

You can use the InSelection property to determine or specify whether a control on a form in Design view is selected. Read/write Boolean.

IsVisible

You can use the IsVisible property in to determine whether a control on a report is visible. Read/write Boolean.

LabelAlign

The property specifies the text alignment within attached labels on new controls. Read/write Byte.

LabelX

The LabelX property (along with the LabelY property) specifies the placement of the label for a new control. Read/write Integer.

LabelY

The LabelY property (along with the LabelX property) specifies the placement of the label for a new control. Read/write Integer.

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.

Left

You can use the Left property to specify an object's location on a form or report. Read/write Integer.

LeftPadding

Gets or sets the amount of space (in inches) between the subform and its left gridline. Read/write Integer.

LinkChildFields

You can use the LinkChildFields property (along with the LinkMasterFields property) together to specify how Microsoft Access links records in a form or report to records in a subform, subreport, or embedded object, such as a chart. If these properties are set, Microsoft Access automatically updates the related record in the subform when you change to a new record in a main form. Read/write String.

LinkMasterFields

You can use the LinkMasterFields property (along with the LinkChildFields property) together to specify how Microsoft Access links records in a form or report to records in a subform, subreport, or embedded object, such as a chart. If these properties are set, Microsoft Access automatically updates the related record in the subform when you change to a new record in a main form. Read/write String.

Locked

The Locked property specifies whether you can edit data in a control in Form view. Read/write Boolean.

Name

You can use the Name property to specify or determine the string expression that identifies the name of an object. Read/write String.

OldBorderStyle

You can use this property to set or returns the unedited value of the BorderStyle property for a form or control. This property is useful if you need to revert to an unedited or preferred border style. Read/write Byte.

OnEnter

Sets or returns the value of the On Enter box in the Properties window of specified object. Read/write String. .

OnExit

Sets or returns the value of the On Exit box in the Properties window of specified object. Read/write String. .

Parent

Returns the parent object for the specified object. Read-only.

Properties

Returns a reference to a control's Properties collection object. Read-only.

Report

You can use the Report property to refer to a report or to refer to the report associated with a subreport control. Read-only Report.

RightPadding

Gets or sets the amount of space (in inches) between the subform and its right gridline. Read/write Integer.

Section

You can identify these controls by the section of a form or report where the control appears. Read/write Integer.

SourceObject

You can use the SourceObject property to identify the form or report that is the source of the subform or subreport on a form or report. Read/write String.

SpecialEffect

You can use the SpecialEffect property to specify whether special formatting will apply to the specified object. Read/write Byte.

StatusBarText

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.

TabIndex

You can use the TabIndex property to specify a control's place in the tab order on a form or report. 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. Read/write Boolean.

Tag

Stores extra information about a form, report, section, or control needed by a Microsoft Access application. Read/write String.

Top

You can use the Top property to specify an object's location on a form or report. 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.

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.

Name

Description

Enter

The Enter event occurs before a control actually receives the focus from a control on the same form or report.

Exit

The Exit event occurs just before a control loses the focus to another control on the same form or report.

Show:
© 2014 Microsoft