DOCUMENT:Q191503 24-MAR-2000 [foxpro]
TITLE :FIX: Unexpected Results Display With Input Mask
PRODUCT :Microsoft FoxPro
PROD/VER:WINDOWS:5.0,5.0a
OPER/SYS:
KEYWORDS:
======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:
- Microsoft Visual FoxPro for Windows, versions 5.0, 5.0a
-------------------------------------------------------------------------------
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.
MORE INFORMATION
================
The InputMask property of fields and controls restricts or dictates the format
of user input. In Visual FoxPro 5.x, if a text box has a numeric field in a
table as a ControlSource and the InputMask property of the text box is set to
999,999.99, entering a number with three or less digits to the left of the
decimal causes an additional zero to remain immediately to the left of the
decimal point. Entering numbers with four or more digits to the left of the
decimal point do not cause the problem with the extra zero.
Steps to Reproduce Behavior
---------------------------
1. Enter the following code into a program file and save the program:
PUBLIC oform1
CREATE TABLE xjunkpr FREE (f1 N(10,2))
oform1=CREATEOBJECT("form1")
oform1.Show
RETURN
**************************************************
*-- Form: form1
*-- ParentClass: form
*-- BaseClass: form
*
DEFINE CLASS form1 AS form
Top = 0
Left = 0
DoCreate = .T.
Caption = "Form1"
Name = "Form1"
ADD OBJECT command1 AS commandbutton WITH ;
Top = 168, ;
Left = 240, ;
Height = 73, ;
Width = 121, ;
Caption = "Quit", ;
TabIndex = 5, ;
Name = "Command1"
ADD OBJECT command2 AS commandbutton WITH ;
Top = 24, ;
Left = 240, ;
Height = 73, ;
Width = 121, ;
Caption = "New Record", ;
TabIndex = 1, ;
Name = "Command2"
ADD OBJECT text1 AS textbox WITH ;
ControlSource = "xjunkpr.f1", ;
Format = "", ;
Height = 25, ;
InputMask = "999,999.99", ;
Left = 24, ;
TabIndex = 2, ;
Top = 24, ;
Width = 168, ;
Name = "Text1"
ADD OBJECT command3 AS commandbutton WITH ;
Top = 168, ;
Left = 24, ;
Height = 49, ;
Width = 73, ;
Caption = "Prior", ;
TabIndex = 4, ;
Name = "Command3"
ADD OBJECT command4 AS commandbutton WITH ;
Top = 168, ;
Left = 120, ;
Height = 49, ;
Width = 73, ;
Caption = "Next", ;
TabIndex = 3, ;
Name = "Command4"
PROCEDURE command1.Click
Thisform.Release
ENDPROC
PROCEDURE command2.Click
APPEND BLANK
Thisform.Refresh
ENDPROC
PROCEDURE command3.Click
SKIP -1
IF BOF()
GO TOP
ENDIF
Thisform.Refresh
ENDPROC
PROCEDURE command4.Click
SKIP 1
IF EOF()
GO BOTTOM
ENDIF
Thisform.Refresh
ENDPROC
ENDDEFINE
*
*-- EndDefine: form1
**************************************************
2. Run the program.
3. Click (or press ENTER) the New Record button to add a new record to the
table.
4. Press Tab once to move the cursor to the text box.
5. Enter a number with a decimal point, for example, enter "5.25" (without the
quotes).
6. Note that once the first digit it entered, 0.00 appears at the right end of
the text box. Then when the decimal is entered, the digit and leading zero
remain and the insertion point moves to the right of the decimal.
Additional query words: kbVFp600fix kbOOP kbvfp500
======================================================================
Keywords :
Technology : kbVFPsearch kbAudDeveloper kbVFP500 kbVFP500a
Version : WINDOWS:5.0,5.0a
Issue type : kbbug
Solution Type : kbfix
=============================================================================
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.
Copyright Microsoft Corporation 2000.