I have created a grid on a page frame. This grid
has three column and the second column is bound to a
table field (doc_tbl.doc_docl). Under the Column2,Header1, is the Txtdoc_docl. When a user enters
this grid column I save the This.Value to a property
on the form in the 'WHEN' method of Txtdoc_docl. In the
'VALID' method of Txtdoc_docl I check to see if the
This.Value property has changed against the saved value
from the 'WHEN' method. If it has changed I want to
ensure of a proper format (ZERO PADDED, e.g 1 becomes
'001'). My statement is as follows:

IF Thisform.r_cOldFieldValue <> This.Value
This.Value = PADL(ALLTRIM(This.Value),3,"0")
IF This.value = "000"
This.Value = " "
ENDIF
This.Refresh
ENDIF

It seems to work fine except the table never gets
updated with the PADDED value.

Can anyone tell me why the This.Value does not update
the field doc_tbl.doc_docl when I force the PADDED value?

Thanks in advance