Microsoft KB Archive/891771

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

Article ID: 891771

Article Last Modified on 4/17/2007

-

APPLIES TO


 * Microsoft Office InfoPath 2007
 * Microsoft Office InfoPath 2003
 * Microsoft Office InfoPath 2003, Service Pack 1 (SP1)

-





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.



CAUSE
This problem occurs when you try to bind a picture control to a field of type &quot;simpleType&quot; and not to a field of type &quot;base64.&quot; 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



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.



STATUS
This behavior is by design.



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   and your , 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.
 * 1) Click Next, and then click Finish to complete the Data Connection Wizard.
 * 2) In the Data Source pane, add the queryFields folder to Drag query fields here on the form, and then click Section with Controls.
 * 3) In the Data Source pane, add the dataFields folder to Drag data fields here on the form, and then click Section with Controls.
 * 4) Delete the default text box that is inserted under the Picture category heading tag.
 * 5) Click Controls in the task pane. Add the Picture control to the Picture category heading tag and to the repeating table.
 * 6) In the Insert Picture Control dialog box, click Included in the form, and then click OK.
 * 7) Expand Categories, click Picture, and then click OK.

You receive the error message that is mentioned in the &quot;Symptoms&quot; section.

Additional query words: kbnoOfficeAlertID inp infp jpg bmp IP2007

Keywords: kbquery kbgraphic kbcontrol kbtshoot kbprb KB891771

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.