SelTop, SelLeft Properties

Applies To

Query, Table.

Description

You can use the SelTop property to specify or determine which row (record) is topmost in the current selection rectangle. You can use the SelLeft property to specify or determine which column (field) is leftmost in the current selection rectangle. For example, if you have selected a group of rows and columns within Datasheet view of the Customer table, you can use the SelTop and SelLeft properties to determine the first row and first column selected in the selection rectangle.

Setting

SelTop — a Long Integer value between 0 and the number of the topmost row in the current selection rectangle.
SelLeft — a Long Integer value between 0 and the number of the leftmost column in the current selection rectangle.

These properties are not available in Design view. These properties are available only in Visual Basic.

Remarks

If there is no selection, the value returned by these properties is the row and column of the cell with the focus.

You can use these properties with the SelHeight and SelWidth properties to specify or determine the actual size of the selection rectangle. The SelTop and SelLeft properties determine the position of the upper-left corner of the selection rectangle. The SelHeight and SelWidth properties determine the lower-right corner of the selection rectangle.

Example