Database Programming Techniques > Accessing Cell Data > Reading cell data from non-current records |
You can read cell data from non-current rows by using the Column object's CellText and CellValue methods.
To examine cell data in any row, where bkm is the bookmark of the desired row:
Example Title |
Copy Code
|
---|---|
RowText$ = TDBList1.Columns(ColIndex).CellText(bkm) RowValue = TDBList1.Columns(ColIndex).CellValue(bkm) |
The CellText method returns a formatted string (according to the column's NumberFormat property) exactly as it appears in the cell. The CellValue method returns the unformatted cell data as a string variant.