FIX: Unexpected Results Display With Input Mask (191503)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 5.0
- Microsoft Visual FoxPro for Windows 5.0a
This article was previously published under Q191503 SYMPTOMS
When typing a new value, such as 5.25, into a blank text box that has an
input mask similar to 999,999.99, an extra zero is added between the
decimal and the last digit entered before the decimal.
CAUSE
This problem occurs when an input mask contains one or more commas and the
number of digits entered before the decimal does not fill out the number of
places to the left of the commas.
RESOLUTION
This problem only occurs in Visual FoxPro 5.x. Visual FoxPro 3.x and 6.0 do
not exhibit this problem. Therefore, upgrading to Visual FoxPro 6.0 is a
possible resolution.
Here are two possible resolutions you can use for Visual FoxPro 5.x:
- Do not use an input mask with numeric data. If the ControlSource of the
text box is a numeric field in a table, you will not be able to enter
alphabetic data into the text box, with or without an input mask. The
drawback to this method is that commas will not show when you enter
large numbers.
- Instead of a Numeric type field in the table, use a Double type field.
Then use the K format code in the Format property of the text box along
with the input mask.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 3/24/2000 |
---|
Keywords: | kbbug KB191503 |
---|
|