Hello Justok
I understand what you are saying but I DO NOT want to effect my data. I just want to blank the forms fields just as if you are appending a blank record. Just like a scatter memvar blank in FPD26. I am not wanting to effect my data or update it in any way shape or form. Just the fields on the form. These fields are tied back to the data. So back to my original question blanking the fields on the SCREEN OR FORM and not my data. I checked out the blank fields and it effects the data which is what I do not want to do.

Thanks Jim.


>Hi James.
>
>You choose a wrong way to Change Data!
>
>See help on Usage of Blank Field, Replace.. With, UPDATE-SQL
>
>To blank a field and show it correctly at form:
>
>Blank Field Field1
>ThisForm.Refresh && or ThisForm.Text1.Refresh
>
>or
>
>Replace Field1 With ""
>ThisForm.Refresh
>
>On handling more in string conversion, see usage of:
>STUFF(), PADL(), SUBSTR(), RIGHT()...
>
>^_~ Good Luck!
>
>
>

---

>>I have this wonderful problem. I have this table attached to the form. The table is buffered with "5" using the cursorprop. I blank the field by saying thisform.field1.text = ''. The problem with this is when I look at the data in the table it is blank on the first field. If I select this record the data is totally blank. If I move from this record to another record everything fills in. If I remove the blanking of the fields it works just fine. How to I blank the fields without blanking my data? I have thought using a database just identical to the one that I am using but selecting it before I select the good one to save the data into it. But this would get cumbersome. Is there an easy way?
>>
>>Thanks Jim