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