clear all fields on a record

[harry8]

Is there a way to maybe click a "Clear Fields" button to clear ALL fields (that have been typed in) on a record? I guess this might be some sort of a script or calculation.

thanks,

Harry

[kenneth2k1]

I'm sure you don't mean ALL fields, because then why wouldn't you just delete the record?

BTW, You have to specify each field you want to clear. You can clear groups of fields by compiling a script that Sets fields to empty.

Ken

[mborgens]

I just had this very question answered by Rigsby. Here are the low downs:

The title of the thread is: Done Gone Bye-Bye, Not

It is currently on pg 2 of Scripts

Script:

------------------------------------------------------------------------

Freeze Window

Go to Next Field

Select All

Set Field Field_Name_Temp

Status( CurrentFieldName) & Status(CurrentRepetitionNumber)

Cut Select entire contents

Loop

Go to Next Field

Exit Loop If Status( CurrentFieldName) & Status(CurrentRepetitionNumber) = Field_Name_Temp

Clear Select entire contents

End Loop

------------------------------------------------------------------------

The trick here is that we not only use the field name to detect the end of the script, but also the repetition number Status( CurrentFieldName) & Status(CurrentRepetitionNumber)

REMEMBER: This script will clear any field (with the exception of calculation fields that are present in your tab order.

mb