A how to question

[bicyleman9008]

We have a VFP 9.0 page with one memo field and many character fields.

When the user clicks on EDIT, the date and user id (ie. 07/06/05-JLK is automatically placed in the memo field along with the cursor, because 90% of the time that field is going to be updated.

However, if this is the 10% that we are not editing that field, we need to manually remove that information.

Suppose I move the cursor out of the memo field with a mouse click or the tab key --- without entering any other data.

Is there a simple way to tell VFP to remove the date, id and line if that is the only data on the top line?

 

[jimstarr]

If the table is buffered you can use the OLDVAL() function to get the memo field back to its original state.

Jim

 

[TamarGranor]

In the code that adds that to the memo, also save a copy to a custom property, something like this:

ThisForm.cMemoDefault = <whatever>

Then, in the LostFocus of the editbox, use code like this:

IF ALLTRIM(This.Value) == ThisForm.cMemoDefault
   * No changes
   This.Value = ""
ENDIF

I'm assuming that if all the user added was spaces, you still want to clear it.

Tamar

 

[bicyleman9008]

Thanks - the input helped. We got it working.