Hi James.
You choose a wrong way to
Change Data!
See help on Usage of
Blank Field, Replace.. With, UPDATE-SQLTo 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
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.