I have a form that is used to create a document, using LotusScript, in one database and then mailed to another.
There is a field on the form that is written to via an agent (we’ll call it field1) - it takes the contents of an editable (rich text) field (let’s call this field2) on the form and adds the contents to field1. Field1 is currently a text field that I want to change to a rich text field because I need to preserve the formatting entered by the user in field2.
I changed field1 to rich text on both forms - the one used in the original database where the document is created and the one used to display the document in the second database.
I had it create a new document using this form. However, the field, which is null when initially created, shows the data type as text. Therefore, when the agent is used to update the field, as a rich text field, the agent errs out because it doesn’t see it as a rich text field.
I just need to be pointed in the right direction. Does anyone have any idea why this might be happening? Is there something I’m overlooking?