I have run into a weird issue with the 'Approval Status' column. Even though require approval is turn off, the column is still displaying in my edit properties. When I go in under Document Library Settings, it does not appear in the list of columns. The values in the drop down are appearing as: 0;#Approve 1;#Rejected 2;#Pending When I try to save after editing properties (without changing any values), I get the message: Failed to get value of the "Approval Status" column from the "Moderation Status" field type control. See details in log. Exception message: Input string was not in a correct format.. To reiterate, this column is not showing up in document library settings, so I cannot remove it. I am running WSS 3.0. Logging is turned off due to disk space issues. Thanks, Dustin

Dustin, Is it possible that the EditForm.aspx page for your list has been customized? If so, it is possible that the column is being displayed in a custom list form and just needs to be removed. If you need to retain the customization then you can manually edit the page to remove the column; if you don't need the customization you may be able to remove the custom list form on the page and restore the default list form. Hope that helps, Chanda

Thanks for the replies. Chanda, the page does not appear to be customized when I go in through SharePoint designer. Rahul, I will test out the code and see if that works, thanks for the suggestion.

Sorry for the long delay in the reply. It took me a while before I had some time to test this. I ran the powershell script and received the following error: "You cannot delete a base type column." Thanks, Dustin

It appears as though an addon running on top of our SharePoint server was causing this abnormal behavior. When the document library was recreated and the files were copied over, they did not have the duplicate Approval Status column. What was that addon? I'm seeing the same situation--the Approval Status column showing up on the Edit form in the same funky manner. The catch is, we need content approval; deleting the column isn't an option. Re-creation is a last resort, as it's also a relatively large list whose version history would be preferrable to retain.Bob

Add a new EditForm1.aspx with SharePoint Designer and set it as a default edit form. pratap

Bob, Check out this sharepoint manager tool. I was able to use it to easily resolve the issue by setting the Approval Status column visibility to hidden. http://spm.codeplex.com/ Regards, Dustin