>hi all,
>
>is there a way to convert it to vfp code
>

>for i= thisform.text1.value to  thisform.text12.value
> if (i)any text <>space""
>    REPLACE (thisform.text2.Value) WITH NEWNAME
>    REPLACE (thisform.text3.Value) WITH NEWNAME
>    REPLACE (thisform.text4.Value) WITH NEWNAME
>    REPLACE (thisform.text5.Value) WITH NEWNAME
>..
>..
>..
>..
>..
>    REPLACE (thisform.text11.Value) WITH NEWNAME
>    REPLACE (thisform.text12.Value) WITH NEWNAME
> ENDIF
>ENDFOR
>

>thanks.

I am not sure exactly what you want to do.

To loop through the textboxes, you might use something like this:

for i = 1 to 12
  loTextBox = eval("ThisForm.Text" + trans(i))
  loTextBox.Value = ...
  loTextBox.Visible = ...
  loTextBox.Top = ...
  * or whatever other property you want to change in each TextBox
next

REPLACE is used for fields in a table. To change the TextBox, just use the .Value property.

If you want to REPLACE table fields, where do you have the name of the fields, and the values?