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

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

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.
This problem occurs because the fields are formatted as rich text. SharePoint List Adapter cannot import rich text fields into an Office InfoPath form.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

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.

Article ID: 896693 - Last Review: 09/22/2011 14:09:00 - Revision: 5.0

  • Microsoft Office InfoPath 2007
  • Microsoft Office InfoPath 2003
  • Microsoft Windows SharePoint Services 2.0
  • kbtshoot kbprb KB896693