PRB: New OLE Field Is Created As Text Box in a New Form

Article ID: Q100138
Creation Date: 16-JUN-1993
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, and 2.0

SYMPTOMS

With a form open in Design view, you drag an OLE field from the field list onto the form. Microsoft Access creates a text box instead of a bound object frame. When you switch to Form view, you can type text in the text box. However, if you open the table the form is based on, you see "Invalid Object" in the OLE field.

CAUSE

If you have a form open in Design view, and then open the table the form is based on in Design view and add an OLE field that you then drag onto the form, this behavior will occur.

RESOLUTION

Save and reopen the form before dragging the new OLE field onto the form. After the form has been saved and reopened, an OLE field that is dragged from the field list onto the form will correctly generate a bound object frame.

MORE INFORMATION

Steps to Reproduce Behavior

Create and save the following table as Table1:

      Table: Table1
      -----------------
      Field Name: Stuff
      Data Type: Text

Create a new form based on Table1 and do not save it. Place the field named Stuff on the form.

      Object: Text box
      ---------------------
      Control Name: Stuff
      Control Source: Stuff

With the form still open in Design view, open Table1 in Design view and add the following field. Save and close Table1.
```
      Table: Table1
      ---------------------
      Field Name: Photo
      Data Type: OLE Object
```
With the form selected, show the field list by choosing Field List from the View menu. Drag the new OLE field, Photo, from the field list onto the form. Microsoft Access will create a text box instead of a bound object frame.

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.