RecValue2 property

Returns or sets an individual value in a record.

Applies to

TableData	ArrData	RsetData	Xdata	XShared
			✓

Parameters

Name	Type	Description
Field	Variant	Number of the field where the value is to be set or returned.

RecValue2 is the same as RecValue except that Field can only be the field number (not name) and is not checked. This is for use where performance is the main consideration.

When setting values in a TableData object, if the source value is of type VbString, and the first character is = or ' or the value is a number or a date, a ' character is placed in front of the value. This ensures that the result is text and the value returned will be the same as the value set.

Record level procedures are used to process records individually in all Xdata objects. In the case of TableData, these record level procedures are buffered (100 worksheet rows at a time) which makes for very efficient sequential processing. However for random processing of datasets larger than 100 rows, this will be inefficient and it is better to use the Buffer, Value or Text properties.