The number of rows the user adds when tabbing from the last data filled row.

Usage

Set_Property(OLECtrlEntID, "OLE.NewRowCount", Value)

Values

Value can be any positive or negative whole number:

Default: 1

Remarks

The NewRowCount sets the number of rows automatically added to the end of the table when the user tabs out of the last cell of the last row. New rows are only added if there is at least one cell with data in the same number of rows at the end of the table. For example, setting NewRowCount to 2 means 2 new rows will be added to the end of the table when the user tabs out of the last row if and only if there is at least one cell with text in the last 2 rows. This is useful for tables maintaining records that span across multiple rows.

If the RowsToRecords property is greater than zero, then this property is set automatically to the same value as RowsToRecords and cannot be changed until RowsToRecords is set back to zero.

The new rows copy the appearance of the rows before it. For example, if the NewRowCount property is set to 3, then the 3 new rows' appearances copy the appearances of the last three rows respectively.

  • No labels