Edit

Share via

SubForm.Left property (Access)

  • Article

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

Syntax

expression.Left

expression A variable that represents a SubForm object.

Remarks

In Visual Basic, use a numeric expression to set the value of this property. Values are expressed in twips.

For reports, you can set these properties only by using a macro or event procedure in Visual Basic while the report is in Print Preview or being printed.

For reports, the Left property setting is the amount that the current section is offset from the left of the page. This property is expressed in twips.

Use this property to specify how far down the page you want a section to print in the section's Format event procedure.

Example

The following example checks the Left property setting for the current report. If the value is less than the minimum margin setting, the NextRecord and PrintSection properties are set to False (0). The section doesn't advance to the next record, and the next section isn't printed.

Sub Detail1_Format(Cancel As Integer, FormatCount As Integer) 
 
 Const conLeftMargin = 1880 
 
 ' Don't advance to next record or print next section 
 ' if Left property setting is less than 1880 twips. 
 If Me.Left < conLeftMargin Then 
 Me.NextRecord = False 
 Me.PrintSection = False 
 End If 
 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.