SharePoint User Group UK

Answer: Apparently when it's in a document library!

I'm confused, I have a content type defined with a couple of columns that are marked as Unlimited length. I understand the restriction around promoting/demoting these properties into the document type, but frankly, I'm not worried, I'm using these columns to store copies of notes gathered during a workflow.

The problem i have is the 255 character limit on the 'Unlimited' text fields. How do we bypass this restriction? I've found an old post relating to changing ows.js in 2003, but can't find similar for 2007.

Any ideas?

Ok, here's a twist.. It works in a standard Document Library column. But my columns are part of a Content type. I've edited them and it would appear that changing to unlimited after the fact doesn't stick!

If you create the field from scratch, it's not an issue.

Underlying database restriction?

Ok, The solution, whilst not ideal does work.

Basically, you have to edit the library that consumes the Content Type. This works, but I'm not sure what effect this will have if you later update the content type parent again and push out the changes.

Ok, I've just tested this, and surprise surprise, as soon as you update the content type, the column gets returned to it's previous setting.. so not ideal, but it will get you out of a jam!

Hi, you may refer to this post - http://www.virtual-generations.com/2007/09/19/sharepoint-2007-link-love-09-19-2007/.

or http://www.ideseg.com/SharePointDestripandoElWiki4.aspx.

you will need to create a new field that inherits from SPFieldMultiLineText. and create your own FLDTYPES.XML file.

All the best!!!

Thanks for that Himani,

I actually got around it in the end by deleting the columns from the Content type.. this orphaned the columns in the existing libraries,

I then recreated the columns as multi line in the content types which created a column with the same name, so you now had the content type column and the orphaned column.

I then copied the data across, then erased the orphaned columns.

Thanks

Paul.