Microsoft KB Archive/163919

= Works: Random Numbers Appear in Blank Database Fields =

Article ID: 163919

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.0 Standard Edition

-



This article was previously published under Q163919



SYMPTOMS
Random data may appear in all blank fields in the Form View of your database. This may happen if the database contains a filter and a serialized field.



To Clear the Random Data From the Database File
You can clear the random data by exiting Works and re-opening the file. The data will not appear again until a filter is applied.

NOTE: This will clear the data even if you have saved the file.

There are several ways to permanently prevent the random data from reappearing:


 * Move the serialized field so that it is the first field in the List View of your database.


 * Change the Serialized field format from Serialized to General and manually enter serialized data.


 * Fill the data down in List View.

For information about how to do this, see the "More Information" section of this article.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Move the Serialized Field to the First Field in List View
To Move the Serialized Field to the First Field in List View, do the following:


 * 1) In List View, click the Serialized Field name to select the entire field.
 * 2) Place your cursor over the Field Name of the selected field so that the word "drag" appears on the cursor.
 * 3) Hold down the left mouse button and drag the Serialized Field to the left until the black line, indicating the field position, is to the left of the first field in the database then release the mouse button.

When you release the mouse button, the field should move to new location.

Changing the Serialized Field to General Format
Change the Serialized Field format by doing the following:


 * 1) Click on the field name of the Serialized field to select it.
 * 2) On the Format menu, click Field.
 * 3) Click General in the Format section and click OK.

Fill Down Serialized Data in List View
You can Fill serialized data down a field column in a database by doing the following:


 * 1) Enter the first number in the series in the first row of the field that you want to contain the serialized data.

NOTE: You can format the number as 00001 by selecting the cell, choosing Field from the Format menu, and formatting the field as a 5 digit fixed number. The example in the appearance window is 01235.
 * 1) Once you've entered the starting number, select the cell containing the number and highlight down the field column as far as you would like to fill the series.
 * 2) On the Edit menu, click Fill Series.
 * 3) Choose the Step By, number you want, and click OK.

Additional query words: 4.00 4.00a 4.50 4.50a w_works works2000 works6 wks garbage numbers corrupt db empty clear

Keywords: kbbug kbfaq kbpending KB163919

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.