How to keep the formatting in a RTF when retrieving data back from DB through Webservice?

leah265 — Wed, 11 Mar 2009 09:40:17 GMT

I am storing the data from the Infopath form in a Database trough a Webservice. The data is saved in the Access DB with formatting, because the Access DB field is defined as RTF too, but when I query the data back into the Infopath form I don't get the data with formatting. Instead I get the whole xml code:

<my:richtext xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2009-03-09T15:17:45"><h4 xmlns="http://www.w3.org/1999/xhtml" style="FONT-WEIGHT: normal"><strong>thanks</strong></h4></my:richtext>

Does anyone know a way to save the data with formatting and retrieve it back with formatting?

I am writing code with Jscript at the moment, so any solutions in that script language would be great.

Controls

How to keep the formatting in a RTF when retrieving data back from DB through Webservice?