SubForm Object Members

  • Article
Access Developer Reference

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

Methods

  Name Description
Bb257428.methods(en-us,office.12).gif Move Moves the specified object to the coordinates specified by the argument values.
Bb257428.methods(en-us,office.12).gif Requery The Requery method updates the data underlying a specified subform by requerying the source of data for the subform.
Bb257428.methods(en-us,office.12).gif 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.
Bb257428.methods(en-us,office.12).gif SizeToFit You can use the SizeToFit method to size a control so it fits the text or image that it contains.

Properties

  Name Description
Bb257428.properties(en-us,office.12).gif AddColon Specifies whether a colon follows the text in labels for new controls. Read/write Boolean.
Bb257428.properties(en-us,office.12).gif Application You can use the Application property to access the active Microsoft Access Application object and its related properties. Read-only Application object.
Bb257428.properties(en-us,office.12).gif AutoLabel Specifies whether labels are automatically created and attached to new controls. Read/write Boolean.
Bb257428.properties(en-us,office.12).gif BorderColor You can use the BorderColor property to specify the color of a control's border. Read/write Long.
Bb257428.properties(en-us,office.12).gif BorderStyle Specifies how a control's border appears.Read/write Byte.
Bb257428.properties(en-us,office.12).gif BorderWidth You can use the BorderWidth property to specify the width of a control's border. Read/write Byte.
Bb257428.properties(en-us,office.12).gif BottomPadding Gets or sets the amount of space (in inches) between the subform and its bottom gridline. Read/write Integer.
Bb257428.properties(en-us,office.12).gif CanGrow Gets or sets whether the specified control automatically adjusts vertically to print or preview all the data the control contains. Read/write Boolean.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif Controls Returns the Controls collection of a form, subform, report or section. Read-only Controls.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif Enabled You can use the Enabled property to set or return the status of the conditional format in the FormatCondition object. Read/write Boolean.
Bb257428.properties(en-us,office.12).gif EventProcPrefix Gets or sets the prefix portion of an event procedure name. Read/write String.
Bb257428.properties(en-us,office.12).gif FilterOnEmptyMaster Gets or sets whether all records are displayed when the subform's master field is Null. Read/write Boolean.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif GridlineColor Gets or sets the color of the gridline for the specified subform. Read/write Long.
Bb257428.properties(en-us,office.12).gif GridlineStyleBottom Gets or sets the bottom gridline style of the specified subform. Read/write Byte.
Bb257428.properties(en-us,office.12).gif GridlineStyleLeft Gets or sets the width of the bottom gridline for the specified subform. Read/write Byte.
Bb257428.properties(en-us,office.12).gif GridlineStyleRight Gets or sets the right gridline style of the specified subform. Read/write Byte.
Bb257428.properties(en-us,office.12).gif GridlineStyleTop Gets or sets the top gridline style of the specified subform. Read/write Byte.
Bb257428.properties(en-us,office.12).gif GridlineWidthBottom Gets or sets the width of the bottom gridline for the specified subform. Read/write Byte.
Bb257428.properties(en-us,office.12).gif GridlineWidthLeft Gets or sets the width of the left gridline for the specified subform. Read/write Byte.
Bb257428.properties(en-us,office.12).gif GridlineWidthRight Gets or sets the width of the right gridline for the specified subform. Read/write Byte.
Bb257428.properties(en-us,office.12).gif GridlineWidthTop Gets or sets the width of the top gridline for the specified subform. Read/write Byte.
Bb257428.properties(en-us,office.12).gif Height Gets or sets the height of the specified object in twips. Read/write Integer.
Bb257428.properties(en-us,office.12).gif HorizontalAnchor Gets or sets an AcHorizontalAnchor constant that indicates how the subform is anchored horizontally within its layout. Read/write.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif IsVisible You can use the IsVisible property in to determine whether a control on a report is visible. Read/write Boolean.
Bb257428.properties(en-us,office.12).gif LabelAlign The property specifies the text alignment within attached labels on new controls. Read/write Byte.
Bb257428.properties(en-us,office.12).gif LabelX Language-specific informationThe LabelX property (along with the LabelY property) specifies the placement of the label for a new control. Read/write Integer.
Bb257428.properties(en-us,office.12).gif LabelY Language-specific informationThe LabelY property (along with the LabelX property) specifies the placement of the label for a new control. Read/write Integer.
Bb257428.properties(en-us,office.12).gif Layout Returns the type of layout for the specified subform. Read-only AcLayoutType.
Bb257428.properties(en-us,office.12).gif LayoutID Returns the unique identifier for the layout that contains the specified subform. Read-only Long.
Bb257428.properties(en-us,office.12).gif Left You can use the Left property to specify an object's location on a form or report. Read/write Integer.
Bb257428.properties(en-us,office.12).gif LeftPadding Gets or sets the amount of space (in inches) between the subform and its left gridline. Read/write Integer.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif Locked The Locked property specifies whether you can edit data in a control in Form view. Read/write Boolean.
Bb257428.properties(en-us,office.12).gif Name You can use the Name property to specify or determine the string expression that identifies the name of an object. Read/write String.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif OnEnter Sets or returns the value of the On Enter box in the Properties window of specified object. Read/write String.
Bb257428.properties(en-us,office.12).gif OnExit Sets or returns the value of the On Exit box in the Properties window of specified object. Read/write String.
Bb257428.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb257428.properties(en-us,office.12).gif Properties Returns a reference to a control's Properties collection object. Read-only.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif RightPadding Gets or sets the amount of space (in inches) between the subform and its right gridline. Read/write Integer.
Bb257428.properties(en-us,office.12).gif Section You can identify these controls by the section of a form or report where the control appears. Read/write Integer.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif SpecialEffect You can use the SpecialEffect property to specify whether special formatting will apply to the specified object. Read/write Byte.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif 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.
Bb257428.properties(en-us,office.12).gif Tag Stores extra information about a form, report, section, or control needed by a Microsoft Access application. Read/write String.
Bb257428.properties(en-us,office.12).gif Top You can use the Top property to specify an object's location on a form or report. Read/write Integer.
Bb257428.properties(en-us,office.12).gif TopPadding Gets or sets the amount of space (in inches) between the subform and its top gridline. Read/write Integer.
Bb257428.properties(en-us,office.12).gif VerticalAnchor Gets or sets an AcVerticalAnchor constant that indicates how the specified subform is anchored vertically within its layout. Read/write.
Bb257428.properties(en-us,office.12).gif Visible Returns or sets whether the object is visible. Read/write Boolean.
Bb257428.properties(en-us,office.12).gif Width Gets or sets the width of the specified object in twips. Read/write Integer.

Events

  Name Description
Bb257428.events(en-us,office.12).gif Enter The Enter event occurs before a control actually receives the focus from a control on the same form or report.
Bb257428.events(en-us,office.12).gif Exit The Exit event occurs just before a control loses the focus to another control on the same form or report.