The field property of the recordset object type is used to retrieve the value of a field of the current record in the current recordset. The isnull function can be used to test if the value of the field is NULL. NOTE: field is a read-only property of type variant.

Currently, this property is read-only so you can not use it to change the contents of the record fields (i.e. you can't use this property to change the database). If you want to change the database call the execute method of the connection object type and pass in a SQL UPDATE statement.


For example, if you have a recordset object reference rs with an open recordset and the records in the recordset have a field named last_name then


constains the contents of the field last_name for the current record in the recordset.

NOTE: Since this property is used so often, you can leave out the name of the property (i.e. field). So for example


is equivalent to



Operating Systems: All
Standard Pascal: No