a field on my form that was previous defined as Rich Text was changed to Text so we can run views and crystal reports against the data. However, even after I chg it to Text (only) I still do not see the field as one of the columns I can select when I create a view. Bottomline is I need to know how to change the field from Rich Text to Text and display all the old data and the new data.
Thanks in advance for any help!
Subject: Rich Text Fields chg’d to text with Views
Dnnis,
you need to write a LC Agent that will hold the text value of the rich text field, then delete the field, and then create the same field with the text value. You may also want to check to see if the user put in any attachments, and if so, put them in a new rt field.
John
Subject: RE: Rich Text Fields chg’d to text with Views
And check that the IsSummary property of your new (text)field is True.
Subject: Rich Text Fields chg’d to text with Views
I am rather inexp with what you are suggesting. What I tried is: I created a new field and define it as edit/text. Went into views to verify that is was listed as a selectable field to insert as a column (it was). I then ran a test bringing in one document with a value in the old field using a view. I then ran my agent that basically did the following it the value in the current field was !=“” do a @setfield to set the new field to the value of the old field. the setfield worked fine but when I tried to add the column to the view the new field name was no longer available which makes me believe that even after setting the new field to the value of the current field the new field became rich text. this stinks…you would think lotus would have an easy solution… sorry for being so wordy but did not have any other way to describe the problem… thanks