Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Some fields are not displayed when you try to create a data connection from an Office InfoPath form to a list on a Windows SharePoint Services site

View products that this article applies to.


When you try to create a data connection from a form in Microsoft Office InfoPath 2007 or in Microsoft Office InfoPath 2003 to a list on a Microsoft Windows SharePoint Services site, some fields are not displayed.

↑ Back to the top


This problem occurs because the fields are formatted as rich text. SharePoint List Adapter cannot import rich text fields into an Office InfoPath form.

↑ Back to the top


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

More information

Steps to reproduce the problem

  1. Create a new custom list on the Windows SharePoint Services site. To do this, follow these steps:
    1. Click Start, click Run, type the URL of the SharePoint Services site, and then click OK.
    2. On the SharePoint menu, click Create.
    3. On the Create page, under Custom Lists, click Custom List.
    4. On the New List page, type RichTextList in the Name box, and then click Create.
  2. Add a new column to the list that you created in step 1. To do this, follow these steps:
    1. In the task pane, under Actions, click Modify settings and columns.
    2. On the Customize RichTextList page, under Columns, click Add a new column.
    3. In the Column name box, type RichTextColumn.
    4. Click Multiple lines of text to set the type of information in the column.
    5. Click to select the Allow rich HTML text check box, and then click OK.
    6. Click the Go Back to "RichTextList" link.
    7. Click New Item. In the Title box, type An example item. In the RichTextColumn field, type This is the second RichText item.
    8. Click Save and Close.
  3. In InfoPath, create a new blank form. To do this, use one of the following methods, depending on the version of InfoPath:
    • In InfoPath 2007, click Design a Form Template, click Blank, and then click OK.
    • In InfoPath 2003, click Design a Form. In the Design a Form task pane, click New Blank Form.
  4. Create a data connection to the Windows SharePoint Services site where you created the RichTextList list. To do this, follow these steps:
    1. On the Tools menu, click Data Connections.
    2. In the Data Connections dialog box, click Add.
    3. In the Data Connections Wizard, click Receive data, and then click Next.
    4. On the second page of the wizard, click SharePoint library or list, and then click Next.
    5. On the third page of the wizard, type the complete URL of the SharePoint list. For example, type http://yourserver/yoursite, and then click Next.
    6. In the list of lists and libraries, click RichTextList, and then click Next.
On the next page of the wizard, notice that the RichTextColumn field is not listed as one of the fields that you can select.

↑ Back to the top

Keywords: KB896693, kbprb, kbtshoot

↑ Back to the top

Article Info
Article ID : 896693
Revision : 5
Created on : 9/22/2011
Published on : 9/22/2011
Exists online : False
Views : 331