Works: Serialized Fields Do Not Increment After Copy/Paste (136700)


The information in this article applies to:

  • Microsoft Works 4.5
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a
  • Microsoft Works 2000
  • Microsoft Works Suite 2000
This article was previously published under Q136700

SYMPTOMS

When you attempt to paste a record that contains a serialized field, the serialized field in the pasted record is no longer incremented, and the formatting of the serialized field is lost.

CAUSE

This behavior is by design.

RESOLUTION

To force the serialized field in the pasted record to be incremented, use the Fill Series command on the Edit menu.

To do this:
  1. In the database List view, select the serialized field.
  2. On the Format menu, click Protection.
  3. Turn off protection on the serialized field. Click OK.
  4. Select the serialized field of the first pasted record.
  5. Enter the correct serial value.
  6. Select the remaining entries of the pasted range of the serialized field.
  7. On the Edit menu, click Fill Series.
  8. Enter the value to add to each field in the Step By: box. Click OK.
  9. On the Format menu, click Field.
  10. Enter the appropriate value in the Next value field and then click OK. Protection is automatically turned on.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbprb kbui KB136700
©2004 Microsoft Corporation. All rights reserved.