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
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.
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.
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.
Steps to Reproduce Behavior
Create and save the following table as 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.
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.
©1997 Microsoft Corporation. All rights reserved. Legal Notices.
Additional reference words: 1.00 1.10 2.00 update