Microsoft KB Archive/148883

= FIX: Setting the Value of a Text Box Adds New Record to Table =

Article ID: 148883

Article Last Modified on 9/30/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition

-



This article was previously published under Q148883



SYMPTOMS
When you programmatically set the Value property of a text box that has its ControlSource property set to a field in a table, a new record will be added to the table if the record pointer is positioned at the end of file.



WORKAROUND
If the Value property of a text box is to be set programmatically, use the EOF function to determine if the record pointer is positioned at the end of file before setting the Value property.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been fixed in Visual FoxPro 5.0 for Windows.



Steps to Reproduce Problem
 Create a new form. Add a table to the data environment of the form. Drag a character field from the table in the data environment to the form. Add a command button to the form.  Add the following code to the Click event of the command button: GO BOTTOM SKIP 1 This.Parent.Text1.Value='test'  Save and run the form.</li></ol>

After you click the command button, a new record is added to the table, and the field that was used to create the text box on the form has a value of test.

Keywords: kbbug kbfix kbvfp500fix KB148883

-

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

© Microsoft Corporation. All rights reserved.