Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How do I erase the contents of a field?

There are two techniques. The first technique is to convert the field from what ever type (i.e. numeric, text, date) it is to a formula field of the same type (i.e. formula-numeric, formula-text, formula-date). Then convert it back to the type it was. This erases the contents of the field. To learn how to change the type of a field please read the following:

The other method involves creating a custom report with all records and two columns. The two columns should be the table's key field and the field that you want to erase. When you've displayed this report click on "Other" and then select "I want to export this view to a spreadsheet". Within the spreadsheet erase the contents of the column you want to erase without erasing the column label at the top of the column. Then select both columns, including the field names at the top of the columns and copy them to the clipboard.

Follow the instructions for copying and pasting from another program in the following help topic:

The columns should automatically map back to the columns that they came from. After you complete the import the column's contents will be erased.


Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit