Reading cell data within the current record

You can read cell data within the current row by using the Column object's Text and Value properties. (The CellText and CellValue methods are used to read values from other, non-current rows.)

To examine cell data in the current row:

Example Title	Copy Code
CurrentText$ = TDBList1.Columns(ColIndex).Text CurrentValue = TDBList1.Columns(ColIndex).Value

The Text and Value properties return the current contents of the specified column in the current row. Note that the contents may have been edited by the user. The Text property returns a formatted string (according to the column's NumberFormat property) exactly as it appears in the cell. The Value property returns the unformatted cell data as a string variant.

To change cell contents in the current row:

Example Title	Copy Code
TDBList1.Columns(ColIndex).Text = NewText$ TDBList1.Columns(ColIndex).Value = NewValue