Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/100138

From BetaArchive Wiki

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


  1. Create and save the following table as Table1:

          Table: Table1
          -----------------
          Field Name: Stuff
          Data Type: Text
  2. 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
  3. 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
  4. 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.

©1997 Microsoft Corporation. All rights reserved. Legal Notices.


Additional reference words: 1.00 1.10 2.00 update
KBCategory: kbole
KBSubcategory: IntpOle