Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ACC2000: Bound OLE Object Is Blank in Form View


View products that this article applies to.

This article was previously published under Q209747
Moderate: Requires basic macro, coding, and interoperability skills.

↑ Back to the top


Symptoms

If a bound object frame on a form has its ControlSource property set to a field that is not of the type OLE Object, the control will be blank when the form is in Form view. In Datasheet view, the cells for the control contain the words "Long binary data."

↑ Back to the top


Cause

A bound object frame must refer to a field of the type OLE Object in a table or query in order to display anything in Form view. To display an object in this control, the ControlSource property must be set to an OLE Object field. For example, Microsoft Access cannot display the contents of a Text field as an OLE Object. Object frames will appear blank unless there is something to show.

↑ Back to the top


Resolution

Select an OLE Object field as the ControlSource property setting for the bound object frame.

↑ Back to the top


More information

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb and create a new form based on the Employees table.
  2. Add a Bound Object Frame control to the form.
  3. Set the control's ControlSource property to FirstName.
  4. Switch the form to Form View. Note that because you are trying to display a Text field (FirstName) in a bound object frame, the object frame is blank in Form view.
  5. Switch the form to Design View.
  6. Set the ControlSource property to Photo.
  7. Switch the form to Form view. Note that the bound object frame now displays a photograph.

↑ Back to the top


References

For more information about the properties of bound object frames, click Microsoft Access Help on the Help menu, type bound object frame control properties in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top


Keywords: KB209747, kbprb

↑ Back to the top

Article Info
Article ID : 209747
Revision : 2
Created on : 6/28/2004
Published on : 6/28/2004
Exists online : False
Views : 286