Retaining Bold, Underline Format.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sunil Yadala - 15 Jul 2005 05:26 GMT

I’m saving bold and underline formatted text from the INFOPATH to SQL SERVER
through XML WEBSERVICE.

The saved text is retrieved and populated in a webpage.

The issue is I’m not able to retain the format i.e., bold, underline.

Data Type used in SQL SERVER is String.

Signature

Thanks & Regards

Sunil Yadala.

Reply to this Message

Scott L. Heim [MSFT] - 15 Jul 2005 14:01 GMT

Hi Sunil,

This is simply the way a database (SQL or Access) functions - standard
"text" fields (varChar in SQL, Text in Access) only store data - not
formatting. As such, when you submit the data from InfoPath to SQL Server,
most likely the database only contains the data.

I am assuming you are using a Rich Text control in InfoPath and the only
way this may be possible is to actually store the underlying XML string for
the Rich Text control. However, this is just a thought off the top of my
head - maybe someone else has implemented a solution like this.

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights

Reply to this Message

Sunil Yadala - 18 Jul 2005 08:48 GMT

Hi Scott,

Yes you are right, i am using rich text control in the Infopath.

Even I am working on accessing XML String in the Infopath

Signature

Thanks & Regards

Sunil Yadala.

P.S: If any one finds the Solution, please update me.

> Hi Sunil,
>
[quoted text clipped - 12 lines]
>
> This posting is provided "AS IS" with no warranties, and confers no rights

Reply to this Message