RTF Text Format & Underline problems

[LindaH]

I've got a Visual Basic 6.0 application that uses several of the MS RichTextBox controls. I'm storing the data entered into these controls into a SQL Server database. I've got the fields defined in SQL Server as "Text."

When I bring these RTF fields into Crystal Reports, as soon as I hit an underline tag in my data field, the rest of the contents of that field are displayed as underlined. It's like Crystal Reports doesn't recognize the RTF closing underline tag.

I've viewed the rtf codes stored in the database, and they are tagged properly, so the problem isn't with the way it's being stored.

Thanks for any help you can offer.

 

[Bazm]

Hi Linda, a gotcha in SQL server is that under a certain file size, a text field may appear as a 'standard' ASCII field. I think it's around 200 char. Resizing to say, 500 or more should enable Crystal to see it as a text field.
Baz.