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.

You receive "A picture control must be bound to a non-repeating field with a picture data type" error message when you try to embed a picture control in InfoPath 2007 or in InfoPath 2003


View products that this article applies to.

Symptoms

You cannot insert a picture control that is not bound to a non-repeating field in a repeating group in a Microsoft Office InfoPath 2007 form or in a Microsoft Office InfoPath 2003 form. When you try to bind a picture control to a repeating field in a repeating group, you receive the following error message:
A picture control whose picture is included in the form must be bound to a non-repeating field with a picture data type. If the field is part of a repeating group, then the picture control must be inside a repeating table or repeating section that is bound to that group.


Note An example of a repeating field in a repeating group is a repeating table.

↑ Back to the top


Cause

This problem occurs when you try to bind a picture control to a field of type "simpleType" and not to a field of type "base64." You try to do this in the source database. A picture control in InfoPath only supports fields of type as follows:
  • base64
  • Other picture data types

↑ Back to the top


Workaround

To work around this problem, you can insert a picture as a static image in the repeating table. The picture that you want to add to the repeating table must be available as a file outside the data source. To insert a picture as a static image in the repeating table, follow these steps.

Note Because the picture is a static element, the picture is visible at all times. The picture is visible both before you run a query and after you run a query on the repeating group. The picture does not change based on the results of the query.
  1. Put the insertion point where you want the picture to appear in the repeating group.
  2. Click Insert, point to Pictures, and then click From File.
  3. Locate the picture that you want to insert, and then click Insert.

↑ Back to the top


Status

This behavior is by design.

↑ Back to the top


More information

Steps to reproduce the problem

  1. Start InfoPath 2003 Service Pack 1.
  2. On the File menu, click Design a Form.
  3. In the Design a Form pane, click New from Data Connection.
  4. On the Data Connection Wizard page, click Database, click Next, and then click Select Database.
  5. In the Select Data Source dialog box, click New SQL Server Connection.odc, and then click Open.
  6. In the Connect to Database Server dialog box, type your Server name and your Log on credentials, and then click Next.
  7. In the Select Database and Table dialog box, click Northwind in the drop-down list, click Categories in the list of tables, and then click Finish.

    Note If you do not use Windows authentication in step 6, you are prompted to enter your password here.
  8. Click Next, and then click Finish to complete the Data Connection Wizard.
  9. In the Data Source pane, add the queryFields folder to Drag query fields here on the form, and then click Section with Controls.
  10. In the Data Source pane, add the dataFields folder to Drag data fields here on the form, and then click Section with Controls.
  11. Delete the default text box that is inserted under the Picture category heading tag.
  12. Click Controls in the task pane. Add the Picture control to the Picture category heading tag and to the repeating table.
  13. In the Insert Picture Control dialog box, click Included in the form, and then click OK.
  14. Expand Categories, click Picture, and then click OK.

    You receive the error message that is mentioned in the "Symptoms" section.

↑ Back to the top


Keywords: KB891771, kbprb, kbtshoot, kbcontrol, kbgraphic, kbquery

↑ Back to the top

Article Info
Article ID : 891771
Revision : 4
Created on : 9/22/2011
Published on : 9/22/2011
Exists online : False
Views : 489