Hi All.
I've got a DB2 database with a LONG VARCHAR field, which I use to store rich-text. I link MS Access to this database to create reports. My problem is that the reports displays the field exactly the way it is stored. If you look at rich text, you'll see that all the formatting is stored with the text, for example, if you have a string "This is my text" as bold, italic and in Arial font, you might get something like "<bold%><%italic%><%Arial%> This is my text <p>". How do I get Access to interpret the string as rich text so it doesn't display all the formatting characters?
I would like to keep the formatting if possible, but it is not that important that the formatting has to be preserved, i.e. if the text is not displayed as bold, italic and in Arial, that is still fine, as long as I can just display the text itself in the report.
Can anybody help me??
I've got a DB2 database with a LONG VARCHAR field, which I use to store rich-text. I link MS Access to this database to create reports. My problem is that the reports displays the field exactly the way it is stored. If you look at rich text, you'll see that all the formatting is stored with the text, for example, if you have a string "This is my text" as bold, italic and in Arial font, you might get something like "<bold%><%italic%><%Arial%> This is my text <p>". How do I get Access to interpret the string as rich text so it doesn't display all the formatting characters?
I would like to keep the formatting if possible, but it is not that important that the formatting has to be preserved, i.e. if the text is not displayed as bold, italic and in Arial, that is still fine, as long as I can just display the text itself in the report.
Can anybody help me??