DOCUMENT:Q196588 06-FEB-2000 [vbwin] TITLE :BUG: Picture Field Dropped as Text Box on Data Report PRODUCT :Microsoft Visual Basic for Windows PROD/VER:WINDOWS:6.0 OPER/SYS: KEYWORDS:kbReportWriter kbVBp600bug kbDataEnv kbGrpDSVBDB ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Visual Basic Enterprise Edition for Windows, version 6.0 ------------------------------------------------------------------------------- SYMPTOMS ======== When you insert a Picture field on a DataReport, it appears as a text box instead of an image box. When you run the report, the picture field displays as a special character. Similar behavior occurs with Binary Large Object (BLOB) fields. CAUSE ===== You cannot drop a Picture field as an image box, because image controls are not bound controls. An error message should have occurred in this situation. STATUS ====== Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. MORE INFORMATION ================ Steps to Reproduce Behavior --------------------------- 1. Start a new Standard .exe project in Visual Basic. Form1 is created by default. 2. From the Project menu, choose Add Data Report. Next, from the Project menu, choose Add Data Environment. 3. Set the Connection property of the Data Environment to a data source that contains a picture field. (The employee table in the NWIND database works in this example). 4. Add a Command Object to the Data Environment and set the SQL statement to the following: Select * from Employees 5. Insert a picture field and text field onto the Data Report. Notice that the picture field is inserted as a text field. If you run the program no error message displays, but the picture field appears as a special character in the report. Additional query words: ====================================================================== Keywords : kbReportWriter kbVBp600bug kbDataEnv kbGrpDSVBDB Technology : kbVBSearch kbAudDeveloper kbZNotKeyword6 kbZNotKeyword2 kbVB600Search kbVB600 Version : WINDOWS:6.0 Issue type : kbbug Solution Type : kbpending ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2000.