Microsoft KB Archive/99538

{| = PRB: Numeric Field Incorrectly Rounds to Two Decimal Places =
 * width="100%"|

ID: Q99538

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
 * Microsoft FoxPro for Windows, version 2.5 and 2.5a

SYMPTOMS
The last two decimal places in a numeric field may be truncated when you type the data in the BROWSE window.

Steps to Reproduce Problem
1. CREATE a database with one numeric field size 19 with four decimal

places. 2. BROWSE the database. 3. Enter the following:

12345678910111.2599

The value displayed is 12345678910111.2500. 4. Now enter: 1234567891011.2599

The value displayed is 12345678910111.2590.

RESOLUTION
To display all four decimal places, create a numeric field size 17 with four decimal places.

Additional reference words: FoxWin FoxDos 2.00 2.50 2.50a floating far KBCategory: kbprg kbprb KBSubcategory: FxprgBrowse
 * }