Microsoft KB Archive/126295

= Cutting Number from Database Form Removes Formatting =

Article ID: 126295

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b

-



This article was previously published under Q126295



SYMPTOMS
Cutting a numeric entry from a formatted field in the database Form view resets the formatting for that field to General. Only the current record is affected; the field entries in other records retain their original formatting. Deleting or clearing the entry does not cause loss of formatting.



RESOLUTION
After cutting a numeric entry, the number format must be manually reapplied:
 * 1) From the Format menu, choose Number.
 * 2) Reapply the previous format (that is, date, currency, and so on).



STATUS
Microsoft has confirmed this to be a problem in Works version 3.0, 3.0a, and 3.0b for Windows. This problem no longer occurs in Works 4.0 and later.



MORE INFORMATION
If a database field is formatted as a date, currency, or other format, and the entry in the field is cut from Form view, the next entry placed in that field will have a General format. If the entry is pasted back in, it is still in a General format; however, if the cut is undone, it retains its original formatting. The database List view does not exhibit this behavior.

Steps to Reproduce Problem

 * 1) Open the sample file WINGLIST.WDB from the Samples directory.
 * 2) In Form view, select the Date Entered field.
 * 3) From the Edit menu, choose Cut.
 * 4) From the Edit menu, choose Paste. The entry has been reformatted to General, and is now appearing as the serial number of the original date entry.

Additional query words: w_works DB

Keywords: kbbug KB126295

-

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

© Microsoft Corporation. All rights reserved.