Modify Method

Object List Next Object

Defined By: Recordset

Description:

Sets or changes the value of the specific field.

Declaration:

Sub Modify (ByVal s As String)

Details:

Using the Row/Column syntax, Modify may be used to alter the value contained at the specified row and column. For example, the following statements will change the contents of the "Name" field in the corresponding record.

<RecordSet>.CurrentRecord.Fields("Name").Modify("Stephen Burns")

<RecordSet>.Row(0).Column(0).Modify("Stephen Burns")

If the underlying database is an ODBC ASCII text file, the Modify method cannot be used to make changes to the data. Currently, the ODBC text driver does not support any saving of data to ASCII textfiles.