Columns Method

Object List Next Object

Defined By: Recordset

Description:

Returns an object that represents the column (field) range beginning at start and having number columns. The column range can consist of an arbitary number of rows.

Declaration:

Function Columns(ByVal position As Long, ByVal number As Long) As Dynaset

Details:

Column values are zero-based, meaning that their first column or field in the underlying database is Column(0). Note that the two values are start column and number of columns, not start column to end column. The following code returns the information in the first (4) columns of the current record in the first example, and all rows in the second example.

Dim s As String
s = <Dynaset>.CurrentRecord.Columns(0,4).Value

s = <Dynaset>.Columns(0,4).Value