Display Sharepoint List Rich Text Fields in an Infopath Form

[funnybroad]

I'm having trouble displaying rich text fields from a Sharepoint list in my
Infopath form.

I have a list on SharePoint 2003. The list has one field called "Statement"
which is defined as follows:
- The type of information in this column is: Multiple lines of text
- Allow rich HTML text (e.g. Bold, Italic, etc.): Yes

I have an InfoPath Form designed in Infopath 2007 with the following 2 data
connections to the Sharepoint list:

1) A data connection defined to "receive" data from a "Sharepoint Library or
List"

2) A data connection defined to "receive" data from an XML data file that is
actually an http string to connect to the list as if it's an XML data file.
(String is in this format:
http://internal.mycompany.com/projects/myproject/_vti_bin/owssvr.dll?Cmd=Display&List={0000XXX0-0000-0XXX-XX00-0000000000X0}&XMLDATA=TRUE)

Problem using data connection 1: I cannot see the field "Statement",
because Infopath cannot see "rich text fields" from sharepoint lists.

Problem using data connection 2: I can retrieve all of records (with rich
text fields) from the list, but when the rich text fields are displayed in my
Infopath form, they are not formatted as rich text... they all look something
like this:

<div>This program is open to IS&T or software testers only.</div>

When I examine this data source using the "Data source:" panel in Infopath,
It looks like this:

- xml
- s:Schema
:id
- ElementType
:name
:content
rs:CommandTimeout
- AttributeType
:name
rs:name
rs:number
- datatype
dt:type
dt:maxLength
-rs:data
-z:row
ws_Statement

Hovering over "z:row" tells me:
row (Field)
Repeating
Data type: simpleContent
Default value: [none]

Hovering over "ows_Statement tells me:
ows_Statement (Optional attribute field)
Data type: string
Default value: [none]

Help!

 

[Charles Harrison]

Have you figured out how to display the data from Richtext from SharePoint in InfoPath?

I'm having trouble displaying rich text fields from a Sharepoint list in my
Infopath form.

I have a list on SharePoint 2003. The list has one field called "Statement"
which is defined as follows:
- The type of information in this column is: Multiple lines of text
- Allow rich HTML text (e.g. Bold, Italic, etc.): Yes

I have an InfoPath Form designed in Infopath 2007 with the following 2 data
connections to the Sharepoint list:

1) A data connection defined to "receive" data from a "Sharepoint Library or
List"

2) A data connection defined to "receive" data from an XML data file that is
actually an http string to connect to the list as if it's an XML data file.
(String is in this format:
http://internal.mycompany.com/projects/myproject/_vti_bin/owssvr.dll?Cmd=Display&List={0000XXX0-0000-0XXX-XX00-0000000000X0}&XMLDATA=TRUE)

Problem using data connection 1: I cannot see the field "Statement",
because Infopath cannot see "rich text fields" from sharepoint lists.

Problem using data connection 2: I can retrieve all of records (with rich
text fields) from the list, but when the rich text fields are displayed in my
Infopath form, they are not formatted as rich text... they all look something
like this:

<div>This program is open to IS&T or software testers only.</div>

When I examine this data source using the "Data source:" panel in Infopath,
It looks like this:

- xml
- s:Schema
:id
- ElementType
:name
:content
rs:CommandTimeout
- AttributeType
:name
rs:name
rs:number
- datatype
dt:type
dt:maxLength
-rs:data
-z:row
ws_Statement

Hovering over "z:row" tells me:
row (Field)
Repeating
Data type: simpleContent
Default value: [none]

Hovering over "ows_Statement tells me:
ows_Statement (Optional attribute field)
Data type: string
Default value: [none]

Help!

Submitted via EggHeadCafe - Software Developer Portal of Choice
Assemblies in Folder Debug Build Checker
http://www.eggheadcafe.com/tutorial...assemblies-in-folder-debug-build-checker.aspx