Knowledge Base

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


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.

MORE INFORMATION

Steps to Reproduce Problem

  1. Create a new form.
  2. Add a table to the data environment of the form.
  3. Drag a character field from the table in the data environment to the form.
  4. Add a command button to the form.
  5. Add the following code to the Click event of the command button:
       GO BOTTOM
       SKIP 1
       This.Parent.Text1.Value='test'
    						
  6. Save and run the form.
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