Table of contents
TOC
Collapse the table of content
Expand the table of content

Form.CurrentSectionLeft Property (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

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.

Syntax

expression. CurrentSectionLeft

expression A variable that represents a Form object.

Remarks

The CurrentSectionLeft property setting changes whenever a user scrolls through a form.

For forms whose DefaultView property is set to Single Form, if the user scrolls to the right of the left edge of the form, the property setting is a negative value.

The CurrentSectionLeft property is useful for finding the positions of detail sections displayed in Form view as continuous forms or in Datasheet view.

Example

The following example displays the CurrentSectionLeft and CurrentSectionTop property settings for a control on a continuous form. Whenever the user moves to a new record, the property settings for the current section are displayed in the lblStatus label in the form's header.

Private Sub Form_Current() 

 Dim intCurTop As Integer 
 Dim intCurLeft As Integer 

 intCurTop = Me.CurrentSectionTop 
 intCurLeft = Me.CurrentSectionLeft 
 Me!lblStatus.Caption = intCurLeft &; " , " &; intCurTop 

End Sub

See also

Concepts

Form Object

© 2017 Microsoft